Remove Duplicates


#1

Hi
image

if name and bdate are same i want older data


#2

Not a perfect solution, but if BDate is string this works.I concatenated columns to find duplicates.

dtDuplicates.AsEnumerable().GroupBy(Function(x) x.Field(Of String)(“Name”)+x.Field(Of String)(“BDate”)).Select(Function(y) y.First()).CopyToDataTable()


How can I find all the values in the duplicate column and merge the duplicate rows?
#3

Hi,

I want to store the duplicated rows in different excel sheet.How could i do that?