how do i omit the a list, and it's matches, so neither exists?

G

Guest

I have a list of mass emails.
I also have a list that i want reps to send out seperatly, so I don't want
these in the mass list anymore.
How do I have excel locate all these names and delete them. Not just delete
duplicates, because that still leaves them in their. I want to show it my
list, and have it remove these names from the mass list, so neither exists.
 
G

Guest

Hi Mark:

The simple one-off solution is to use vlookup.

As in

in a new column on the mass list sheet with the name in column a and also on
the reps sheet (here called reps) enter:

=if(isna(vlookup(a1,reps!a:a,1,false)),"<<<","")

that will find all the names that are the same on the reps sheet.

you name need to consider using trim and lcase on the names first to reduce
typos.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top