Compare/Merge 2 spreadsheets

G

Guest

Hi,

I have 2 spreadsheets, one has 8000 records, the other has 8200 records.
They both have first name and last name columns, but the 8200 spreadsheet has
200 more different names than the 1st spreadsheet. Is there a way to merge
these 2 or display which ones are missing or different? I have a 3rd column
in the 1st spreadsheet that I want to add to the 2nd spreadsheet, but it's
not matching up with the right names because there are 200 extra.

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I automatically compare 2 versions of a spreadsheet 1
help with vlookup to merge two lists 8
Appending Data from one spreadsheet to another 4
IF Statement Help 6
merging spreadsheet data 1
merging spreadsheets 2
Match 2 fields in 2 seperate Spreadsheets and fill another column 1
Spilting a column 6

Top