How to filter email addresses on Excel ?

[edinn10]

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,

[xor]

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.

[edinn10]

xor thank you, It didn't work, may I send you a file and you can try your formula please,

download here a demo of my excel file, Download

Thank you very much,

[NoSparks]

What column are you wanting to filter on ?

Is the file you link to download the same file you send over at MrE ?

[Pecoflyer]

Originally Posted by edinn10

xor thank you, It didn't work, may I send you a file and you can try your formula please,

download here a demo of my excel file, Download

Thank you very much,

Hi
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

[xor]

@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.

[NoSparks]

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.

[NBVC]

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....