Comparing 2 spreadsheets

M

mhan487

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?
 
P

Pete_UK

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
 

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

Top