Compare File Data ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erskin! - 09 Jul 2007 15:47 GMT

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.

Reply to this Message

Dave Peterson - 09 Jul 2007 16:17 GMT

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

> 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.

Signature

Dave Peterson

Reply to this Message

Erskin! - 10 Jul 2007 15:02 GMT

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
[quoted text clipped - 4 lines]
>> I have a column with a primary key, is it possible to compare the two
>> files? Thank you.

Reply to this Message