View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RunOrDie RunOrDie is offline
external usenet poster
 
Posts: 2
Default looking to delete "non-matched" data

I have two lists done in excel.

An older one, List-A, with separate columns for name, street, city, email
addresses, company name, etc. and a newer one, List-B, that has just one
column of current email addresses that will match some of those in List-A.

I know I can copy the data from List-B into List-A and I'll end up with
duplicate emails of those I want to keep.

How can I delete the ones from List-A that have no match from List-B?

I looking for the opposite of getting rid of the duplicates - :)
Best wishes - DG