Finding Duplicate Values in two different spreadsheets

B

Bill from CT

I have two customer lists in Excel.. Column A in both spreadsheets is the
customer number.. I am looking for a way to compare column A in both
spreadsheets to indentify if there are any duplicates ?? Can anyone help me
with a way to do this ? Otherwise, I will have to manually compare over 3000
records for duplication.. YIKES
 
M

Myrna Larson

I assume you have headers in row 1. Insert another column, say B. Put this
formula in B2 and copy it down.

=IF(ISNUMBER(MATCH(B2,Sheet2!$A$1:$A$3600,0)),"DUPLICATE","")

Adjust the cell ranges to suite.

You'll see the word DUPLICATE for any entries on this sheet that are also
found on Sheet2. Put an analogous formula on Sheet2 if necessary, looking up
those entries on Sheet 1.



On Wed, 11 Aug 2004 05:49:03 -0700, Bill from CT <Bill from
 
Top