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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"markcjr" wrote:
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.