Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 spreadsheets
I'm comparing two spreadsheets with a bunch of names on each. I have to find
a way to see which names are missing on one spreadsheet to the next. For example, John Smith, John Anderson, and Mike Smith might be on both spreadsheets, but Larry Smith might only be on one. How do I filter out which ones are missing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 spreadsheets
Are these two sheets in the same workbook? Assuming they are, and that
your names are in column A starting with A1, then put this formula in B1 of Sheet1: =IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"Unique","in both sheets") and this one in B1 of Sheet2: =IF(ISNA(MATCH(A1,Sheet1!A:A,0)),"Unique","in both sheets") Copy both formulae down the columns, then apply Autofilter to column B on each sheet. If you choose "Unique" from the filter pull-down in each sheet, you will see those names which are only present on that sheet. Hope this helps. Pete On Aug 28, 3:46*pm, mhan487 wrote: I'm comparing two spreadsheets with a bunch of names on each. I have to find a way to see which names are missing on one spreadsheet to the next. For example, John Smith, John Anderson, and Mike Smith might be on both spreadsheets, but Larry Smith might only be on one. How do I filter out which ones are missing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two different spreadsheets | New Users to Excel | |||
Comparing spreadsheets | Excel Worksheet Functions | |||
comparing 2 spreadsheets | Excel Discussion (Misc queries) | |||
Comparing Spreadsheets | Excel Worksheet Functions | |||
Please Help (Comparing Spreadsheets) | Excel Worksheet Functions |