Eliminating duplicate rows by comparing values in different cells

[ppr (Peter Preuss)]

@parimala.prata
Have a Look Here
Linq query to identify duplicates and delete both entries - #3 by ppr

And Here

Could you help me insert a new column in an excel file, enhance it and eliminate duplicates from the table?Thanks

@vittoria I have for time reasons implemented with a smaller set of sample data, but it can be extended easy to more columns configure in the default values the cols for concatenation and concat colname [grafik] data in: [grafik] data Concated with configured columnname: [grafik] Duplicates [grafik] Non Duplicates [grafik] with filter datatable and set to the remove column colname = ConCatCol you can easy remove the concat column Find starter Help here: DupNonDup_ByConfColList_Con…