Automatically Deleting a List from Another (Larger) List

  • Thread starter Thread starter ddethomas
  • Start date Start date
D

ddethomas

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? ...
Click to expand...

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
 
Back
Top