0
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.
Edin Neziri
Posted 2017-05-31T12:19:25.563
Reputation: 11
0
This is what I've done for a similar task
Let me know if you need more insight, or if I'm off target here.
gns100
Posted 2017-05-31T12:19:25.563
Reputation: 571
Thank you, In fact, to be honest, I don't understand what you are saying can you please check this video I did, this is what I need unique values from company/domain, please check the video.
Video - https://streamable.com/5z8d9
video looks different from your ask, but seems the same as this: https://superuser.com/questions/1211913/how-to-sort-5-by-5-in-excel/1212608#1212608
– gns100 – 2017-06-01T19:19:58.703
Ouch... sounds like a job for some VBA to create an array of domain names (and another element to contain a "sample" email address) but your loop will need to check to see if the domain name portion of the email address being read is already in the array, if it is then move to the next else add it to the array with the associated person's email address... bearing in mind the script would not be efficient as it would need to scan 30,000 rows and you'll only always get the first occurrence of the domain name found... – Kinnectus – 2017-05-31T12:35:53.110
4You might want to consider providing dummy data for your example. Exposing all of that personal data on a public site may well be breaking a few privacy laws ... – DavidPostill – 2017-05-31T12:56:20.793
1Oh hey... free spam targets! – Burgi – 2017-05-31T12:58:01.353
Screen shot removed. – DavidPostill – 2017-05-31T12:58:51.587
You want to break it into two halfs, get the half after the @ and filter on that. No, I don't know how to do this in excel :/ – djsmiley2k TMW – 2017-05-31T13:00:41.297
This can be done in VBA though I'm a little unclear as to what you're trying to achieve. Do you just need to know how many different domain names you have in your list of 30,000? – Stephen – 2017-05-31T13:41:29.963
@Stephen I want to get 5 unique values, from one domain, and then continue until the list is finished. like in this pic, http://i.imgur.com/2wpjpue.jpg
– Edin Neziri – 2017-05-31T13:51:25.840What is 3st Unique ? – Dave – 2017-05-31T14:32:19.893