Compare File Data ?

[Erskin!]

Is there any way to compare data in two Excel spreadsheets? Let's say
I've got 10000 line items in one file and 9000 in another. I'd like to
find out which 1000 items are missing from the one file. Assuming that
I have a column with a primary key, is it possible to compare the two
files? Thank you.

 

[Dave Peterson]

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

 

[Erskin!]

Thanks Dave, I'll give it a look.

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm