Hello There,

I'm new to these parts and I'm hoping someone can help me. I have a
simple email list of 4000 addresses (List A) and some are no good.
I've made a separate list (List B) of those bad email addresses and
want to delete all of them from the initial list (List A). Is there a
way of doing this without doing it manually? A formula of some sort?
It feels like there should be, but I can't figure it out. Thank you
kindly for any assistance.

-- Dylan

> ... I have a
> simple email list of 4000 addresses (List A) and some are no good.
> I've made a separate list (List B) of those bad email addresses and
> want to delete all of them from the initial list (List A). Is there a
> way of doing this without doing it manually? ...

Here's one way, with the original list in column A of Sheet1 and the "bad"
list in column A of Sheet2.

In cell B1 of Sheet1 put
=COUNTIF(Sheet2!A:A,A1)>0
Extend B1 down to the lend of the list.

Select Sheet1 column B and use
Data > Filter > AutoFilter
A pull-down will appear at the top of the column.

In the pull-down select "TRUE" -- only the "bad" addresses will be visible
now.

Use ctrl-A to select all.

Use
Edit > Delete

Finally, delete column B.

Please do NOT multipost to waste the time and effort of others. See your
other post in excel

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello There,
>
> I'm new to these parts and I'm hoping someone can help me. I have a
> simple email list of 4000 addresses (List A) and some are no good.
> I've made a separate list (List B) of those bad email addresses and
> want to delete all of them from the initial list (List A). Is there a
> way of doing this without doing it manually? A formula of some sort?
> It feels like there should be, but I can't figure it out. Thank you
> kindly for any assistance.
>
> -- Dylan
>