Filter Excel Record based on Latest date record

hi @Yoichi

Upon Reading the record,
The headers is unchecked.
image
Because it has a duplicate column in the record

image

so i must read it without header to get the 1st Column (Person Number)
But it thorws me error like this

in_dtRoaster.AsEnumerable.GroupBy(Function(r) r(“Column1”).ToString).Select(Function(g) g.OrderBy(Function(r) DateTime.Parse(r(“Column15”).ToString)).Last).CopyToDataTable

image

Please help
Thank you