How to delete values of a cell if it is found in another coloumn

K

karty

Hi,

I have a list of about 10000 emails. They contain some good email
and some bad emails. I have figured out the bad emails and have a lis
of about 4000 - 6000 emails. Now i need to delete the bad emails fro
that 10000 email list.

Please help me to figure out this problem. If you can email m
please email me @ > [email protected]
 
G

Gary''s Student

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.
 
D

Dave Peterson

I bet you wanted:

=MATCH(A1,C:C,0)

instead.

I think I'd use a slightly different formula:

=isnumber(match(a1,c:c,0))

If it's true, then there's a match. If false, then there's no match.

(It might be just a bit prettier than #n/a's and a bunch of numbers <vbg>.)
 
Top