#1
|
|||
|
|||
How to filter email addresses on Excel ?
Hi everyone, I need to filter multiple email addresses on Excel. Our "email list" comprises of similar and unique domain names. The issue I am having is separating email addresses that have a magnitude of similar domain names in them. For example. I have 50 JP Morgan, 35 Citi Bank and 20 TD Bank Email Addresses under one column. My question is - how do I extract one of each (unique value) on a grander scale of 30,000 contacts. Screenshot (deleted by Mod) Thank you, Last edited by Pecoflyer; 08-03-2017 at 06:36 AM. |
#2
|
|||
|
|||
In I2 enter:
MID(C2,FIND("@",C2)+1;LEN(C2)) and copy down. Name range with these formulas d. In J2 enter the following array formula: =IFERROR(INDEX(d,MATCH(0,COUNTIF($E1:E$1,d),0)),"" ) Remember to hold down Ctrl and Shift before pressing Enter. Copy the formula down. |
#5
|
||||
|
||||
Quote:
please do not ask questions/solve problems via PM, so that all members can profit from the solution. Also, please post your sample file (not pictures ) on the forum. Not everybody has access to external links possibly depriving you from part of the help you can get Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
@Pecoflyer
I haven't got any PM. @edinn10 As you couldn't use what I sent earlier I guess I haven't understood the problem. Please be more exact as to what you want. Is it unique e-mail addresses, unique domain names or something else. |
#7
|
|||
|
|||
I got a PM from the OP and I ignored it. Goes totally against the intent of these forums.
All the OP needs to do to get the assistance they're looking for is show what they want to end up with. So far, in 3 different topics which seem to be related, they made sure we see what they start with but are yet to show what they want for results. |
#8
|
||||
|
||||
Let alone that if those are real names and emails, the owners would not be to happy having them posted for the world to see, along with their company names, and abuse....
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
need to extract email addresses from excel files | dunndealpr | Excel | 3 | 06-07-2013 08:29 AM |
Incorrect Email Addresses | StuartDAB | Outlook | 1 | 03-04-2011 07:01 PM |
Duplicate Email Addresses | lh66 | Outlook | 2 | 02-20-2011 07:32 PM |
Export all email addresses | Rich12345 | Outlook | 1 | 02-02-2011 10:16 AM |
How Many Email Addresses Can You email at one time in Outlook | zinfandel72 | Outlook | 2 | 08-04-2008 06:39 AM |