View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NickySams NickySams is offline
external usenet poster
 
Posts: 4
Default Eliminating duplicated data completely or something similar

Say I have 2 lists. One of which we'll call citizens, the other we'll call
enemies. everyone on the citizens list should also be included in the Enemies
list, but they're not. I'm trying to have it list the names that do not show
on the enemies list. How would I go about doing this? Is it an INDEX function
or a MATCH function? Been tearing my hair out on this one. Thanks!