Put your large (total ) list in column A and you list of bads in column C. In
B1 enter:
=MATCH(A1,C:C) and copy down. Then sort all three by column B. If column B
show #N/A then the entry is good. If column B shows a number the entry is
bad and should be removed.
--
Gary's Student
"karty" wrote:
Hi,
I have a list of about 10000 emails. They contain some good emails
and some bad emails. I have figured out the bad emails and have a list
of about 4000 - 6000 emails. Now i need to delete the bad emails from
that 10000 email list.
Please help me to figure out this problem. If you can email me
please email me @
--
karty
------------------------------------------------------------------------
karty's Profile: http://www.excelforum.com/member.php...o&userid=28278
View this thread: http://www.excelforum.com/showthread...hreadid=478430