Remove bad addresses
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? |
Remove bad addresses
ALso, I should note that I am using an older version of Excel. 2003.
"bejewell" wrote: 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? |
Remove bad addresses
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 On Aug 26, 7:50*pm, bejewell wrote: ALso, I should note that I am using an older version of Excel. 2003. "bejewell" wrote: 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?- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 10:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com