ExcelBanter - Data Comparison

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Comparison (https://www.excelbanter.com/excel-discussion-misc-queries/181915-data-comparison.html)

Is there a way to compare 2 sheets of data and gets results that lists which
records are duplicates and which records are unique? Will this also count
the number of duplicate and unique records?

Excel 2000
--
LPS

Do you only want to compare Sheet1 to sheet2 or do you also want to compare
sheet2 to sheet1? How do you want the results presented? Do you want
unique records colored one color and the duplicates another? Or do you want
each group listed somewhere? Where? Or do you want to see a message box
telling you the results? Yes, the count of each can be included. HTH Otto
"LPS" wrote in message
...
Is there a way to compare 2 sheets of data and gets results that lists
which
records are duplicates and which records are unique? Will this also count
the number of duplicate and unique records?

Excel 2000
--
LPS