Separate Duplicate data

[ppr (Peter Preuss)]

@siming
Have a look Here

Isolate multiple rows with duplicate column values

@Hisuhong find attached sample seperating the Duplicates and NonDuplicates and writes out into 2 different Worksheets Hisuhong.xaml (10.0 KB) Result for Reference: Result.xlsx (9.1 KB) the main Ideas were to Identify the Duplicates / NonDuplicates on its occurence validating the 4 columns this was solved with using the Keys for a GroupBy and Count E.g. NonDuplicates: (From r In dtOrigin.AsEnumerable() Select C1 = r(0).ToString.Trim, C2 = r(1).ToString.Trim, C3 = r(2).ToString.Trim, C4 =…

Remove Duplicate with condition

Hi @arivazhagan_mathivan I did reread all the posts and confirm to @amaresan. Based on your second table all N are to remove. And this would be the simplest (e.g. FilterTable or LINQ) Let me reformulate your requirements, maybe you are looking for some different: If a N row ABI # Value exits in a NON-N row ABI # Value then we got a Duplicate Mission: remove the duplicates (means N rows) [grafik] N-AA exists not in NON-N so keep, Keep Y-DD as well, Keep NON-BB,CC Remove N-BB, N-CC So this…

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…

Let US know your Open questions