Comparing 2 spreadsheets

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

 

[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