Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare/Merge 2 spreadsheets
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare/Merge 2 spreadsheets
http://www.geocities.com/excelmarksway
"PML" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine information about products from 2 spreadsheets | Excel Worksheet Functions | |||
Spreadsheets are cut off when you paste and link? | Excel Worksheet Functions | |||
Applying Print Settings to Several Spreadsheets At Once | Excel Discussion (Misc queries) | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) |