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

[markcjr]

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.

 

[Max]

Try this sample from my archives* ..
It's tailored for the intents that you seek <g>:
http://savefile.com/files/103141
Extracting an exclusion list.xls
(nicely rendered, full details, easy to understand and adapt)

*archives link in sign-off

 

[Martin Fishlock]

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.

 

[Max]

Sorry, the earlier link should have read as:
http://savefile.com/files/103141
Extracting an exclusion list.xls

Earlier link pasted carried an unwanted semicolon
which I missed cleaning off.