Remove bad addresses

  • Thread starter Thread starter bejewell
  • Start date Start date
B

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