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!

Thank you,

 

[wisewood]

what do you mean by extract?

 

[edinn10]

wisewood I need to sort like this, but I have a lot of columns

 

[wisewood]

Have you thought about a pivot table for it?

 

[edinn10]

wisewood No, I'm trying with Kutools but it's manually and takes the time to colour unique than again colour unique it may take 2 days for 10k contacts. may I send a file and maybe you can help me to check if you can do that?

 

[wisewood]

Sure. me@andrewjam.es