Thread: Matching Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joey Joey is offline
external usenet poster
 
Posts: 45
Default Matching Data

I have a worksheet that has all account numbers and names - 15,000 of themand
another worksheet that has some of the same account number and names - about
8,000.

Is there a way in Excel to match records so that I can see the 7,000 records
that are not associated with the 2nd worksheet? Or, do I need to use Access.

Thanks