Large Number of Records in Excel

[Palaniyappan (Forum Leader)]

Kindly have a view on this to get duplicate records

How to get duplicate rows for specific column in a datatable

Hi, Please find the reference, DataTable filtering with expressions But the above reference code is removing the row instead of storing it in another datatable… How do I get the duplicate values using LINQ

And for non duplicates

Filter/Select Non Duplicate Values

@kuppu_samy Below a more detailled description on how to do (1 column, List approach) [grafik] Build Datatable - just simulating Excel readin, giving a Datatable 1. Assign: creating a string list from the Numbers column dtData.AsEnumerable.Select(Function (row) row(“Numbers”).toString.Trim).toList 2. Assign: retrieving the duplicates: (From s In Numbers Group s By no=s Into Group Select no, count=Group.Count Where count>1 Select no).ToList 3. Assign filtering out the dplicates from…

Cheers @Nafseeidri