Automatically Deleting a List from Another (Larger) List
 

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

Automatically Deleting a List from Another (Larger) List
 

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

Automatically Deleting a List from Another (Larger) List
 

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

wrote in message
oups.com...
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