Removed Rows Based On Dupe And Missing Value Logic

[sharazkm32 (Sharaz K M)]

Easiest solution i could think of is as given below

1. Sort the Datatable using Column DateCol in descending order ’
2. Use linq query to remove duplicate based on a specific column
   dtTable = dtTable.AsEnumerable().GroupBy(Function(r) r.Field(of String)(“DupeCol”)).Select(Function(s) s.First()).CopyToDataTable

Attaching sample project folder for your reference. Let me know your feedback

RemoveDuplicates.zip (124.0 KB)