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

[karty]

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 @

[email protected]

[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.
--
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 @ > [email protected]
>
>
> --
> karty
> ------------------------------------------------------------------------
> karty's Profile: http://www.excelforum.com/member.php...o&userid=28278
> View this thread: http://www.excelforum.com/showthread...hreadid=478430
>
>

[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>.)

Gary''s Student wrote:
>
> 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 @ > [email protected]
> >
> >
> > --
> > karty
> > ------------------------------------------------------------------------
> > karty's Profile: http://www.excelforum.com/member.php...o&userid=28278
> > View this thread: http://www.excelforum.com/showthread...hreadid=478430
> >
> >

--

Dave Peterson

[Gary''s Student]

Good catch Dave. My small sample did not catch my error.
--
Gary''s Student


"Dave Peterson" wrote:

> 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>.)
>
> Gary''s Student wrote:
> >
> > 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 @ > [email protected]
> > >
> > >
> > > --
> > > karty
> > > ------------------------------------------------------------------------
> > > karty's Profile: http://www.excelforum.com/member.php...o&userid=28278
> > > View this thread: http://www.excelforum.com/showthread...hreadid=478430
> > >
> > >
>
> --
>
> Dave Peterson
>