Excel Question
Solved/Closed
Hello,
I have one worksheet with with all of my emails (both good and bad) D2:D3843 and another worksheet A2:A1061 with all good emails and I need to remove all of the bad emails from the first worksheet.... Any Ideas?
I have one worksheet with with all of my emails (both good and bad) D2:D3843 and another worksheet A2:A1061 with all good emails and I need to remove all of the bad emails from the first worksheet.... Any Ideas?
Related:
- Excel Question
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
Nov 3, 2010 at 10:15 PM
Nov 4, 2010 at 11:56 AM
On your excel worksheet that has the "good" emails, create an extra column. For simplicity, you'll have two columns, column A will have your "good" emails, and column B will have the value "good email" for all your records in column B. Highlight all the records for that worksheet, then on the Menu Toolbar go to INSERT > NAME > DEFINE. You will define this range of selection, and name it something meaningful. I used goodemail as my name. Press OK to add to the defined list.
On your "good/bad" worksheet, for simplicity, you will have two columns, again column A will have all emails of good/bad, and place your formula on column B. Column B will have formula as follows =vlookup(A2,goodemail,2,false). A2 indicates the cell you are trying to reference, goodemail is the reference location, 2 is the column you need to reference, and false indicates it needs an exact match. Feel free to further google how to use vlookup if my explanation is a bit vague.
Records that show up with the value "good email" are just that, your good emails, and values that indicate "#N/A", means it could not find that record, hence its your bad emails.