Comparing data between files

[jmenkin]

Hi,
I have two files that have lists of names, first and last in separate
columns. I would like to be able to quickly find out if there are any repeats
between the two documents. The names could be in any order, so I don't know
how to compare cells, and I'm guessing trying to create a macro to search for
the contents in each cell in the 2nd document might be a little slow. Ideas?
Thanks!

 

[joel]

the easy way is to use a sumproduct formula. for eample if you hav
the first and last names of one workbook in column A & b going to ro
1000 and the 2nd set of names in columns C & E.


Put in column e
=sumproduct(--(C1=A$1:A$1000),(D1=B$1:B$1000))

Then copy formual down column until you reach the last row of column
& d.


The non duplicates in column C & D will result in a value of zero.


Look at Chip Pearson website under duplicates in a list

'CPearson.com Topic Index' (http://www.cpearson.com/Excel/topic.aspx)