Removed Rows Based On Dupe And Missing Value Logic

@dominic.luke

Welcome to the community

Please try this

Dt.AsEnumerable.OrderByDescending(function(x) Cdate(x(0).ToString)).GroupBy(function(x) x(1).ToString).Select(function(x) Dt.LoadDataRow({x.First()(0).ToString,x.Key,x.First()(2).ToString},False)).CopyToDataTable

Cheers