R
RunOrDie
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
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