View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mhan487 mhan487 is offline
external usenet poster
 
Posts: 1
Default 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?