Compare Spreadsheets 1

[randy700]

I have 2 spreadsheets, both with the same column headings. The first one has 13000 records. The second has about 1200 records.

I need to compare the two files and create a list of records that are duplicated in both files.

I then need to create a list that is unique to the larger file.

Any suggestions would be very much appreciated.

An added glitch -- some records in each file are duplicated within the file. Do I need to eliminate them first or can this be accomplished with them in place?


Randy

 

[SkipVought]

Hi,

I often use the MATCH function to determine what values are in both lists.

You could also use MS Query. faq68-5829

Use INNER and OUTER joins to determine the answer.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[kjv1611]

If you have Microsoft Access, you could also import them both into Access, and then run a query, and determine how you want to handle matches/duplicates there.

--

"If to err is human, then I must be some kind of human!" -Me

 

[randy700]

Skip,

The MATCH function worked perfectly.
Thank you.


Randy