Data Comparison

L

LPS

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
 
O

Otto Moehrbach

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find duplicates in address register 2
How to find dublicates in Excel and delete it? 6
Highlighting duplicate cells in a column 2
Advanced Filter Grayed Out??? 3
Identifying duplicate rows 2
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Unique Pivot Table Count 1

Top