Remove bad addresses

[bejewell]

I have a workbook with two spreadsheets: the first is a list of email
addresses. The second is a list of email addresses that are bad.

I need to remove any addresses from the first list that also appear in the
second - i.e., I need to remove all bad email addresses from the first list.

I've seen other posts about this but haven't been able to figure out the
coding thing. Just want a very simple way to do this. Is there such a
thing?

 

[bejewell]

ALso, I should note that I am using an older version of Excel. 2003.

 

[Pete_UK]

Assume your email addresses are in column A of both sheets, and that
the second sheet is named "Bad" - put this in B1 of the first sheet:

=IF(ISNA(MATCH(A1,Bad!A:A,0)),"","bad")

then copy this down. It will give you the word "bad" against any
addresses which appear in the Bad sheet. Apply autofilter to this
column, selecting "bad" from the filter pull-down. Then highlight the
visible data and click on Edit | Delete Row. Then select All from the
filter pull-down, and then delete column B.

Hope this helps.

Pete