Searching values and arranging rows in Excel

[ppr (Peter Preuss)]

have a look here on how to deal with all columns without explicit definition of compare rows:

[HowTo] - Find Duplicate / NonDuplicate rows - checking all columns - without explicit listing the colnames/index

Introduction In the majority of scenarios duplicated / Non duplicated rows can be identified by a few columns grace to the key column concept. In order to retrieve it, the group by approach helps It can be done e.g. with some nice components from Connect or LINQ In some scenarios all duplicated / non duplicated rows should be detected by checking all columns. Setting up an approach without explicit listing all column names or column index would speed up the implementation. Implementat…

sometimes GroupBy can be helpfully and in a merged datatble the different datatable sources can be marked in an extra column

However I would suggest to work out a sample data set more representing the complexity of your case. Then the options for the solution approach can be cross checked and evaluated