Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove convert/extract the number from'12345.56; ie remove ' sign | Excel Worksheet Functions | |||
How do I remove hyperlink if 'remove' option is disabled | New Users to Excel | |||
Addresses | Excel Discussion (Misc queries) | |||
Email Addresses | Excel Discussion (Misc queries) | |||
Help with Addresses | New Users to Excel |