View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DD
 
Posts: n/a
Default Screening one list for data

I'm such a newbie, I thought this would be embarassingly easy but two hours
later...hopefully someone can help! I have two long lists of values; in list
#1, there are about 800 unique values, whereas in list #2, there are 366
unique values. I want to be able to identify which values can be found in
both lists, but have failed to master COUNT/LOOKUP/etc. Would love any
suggestions.