Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2017, 05:25 AM
edinn10 edinn10 is offline How to filter email addresses on Excel ? Windows 10 How to filter email addresses on Excel ? Office 2016
Novice
How to filter email addresses on Excel ?
 
Join Date: May 2017
Posts: 6
edinn10 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-31-2017, 06:43 AM
xor xor is offline How to filter email addresses on Excel ? Windows 10 How to filter email addresses on Excel ? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

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.
Reply With Quote
  #3  
Old 05-31-2017, 11:29 AM
edinn10 edinn10 is offline How to filter email addresses on Excel ? Windows 10 How to filter email addresses on Excel ? Office 2016
Novice
How to filter email addresses on Excel ?
 
Join Date: May 2017
Posts: 6
edinn10 is on a distinguished road
Default

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,
Reply With Quote
  #4  
Old 05-31-2017, 03:58 PM
NoSparks NoSparks is offline How to filter email addresses on Excel ? Windows 7 64bit How to filter email addresses on Excel ? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

What column are you wanting to filter on ?

Is the file you link to download the same file you send over at MrE ?
Reply With Quote
  #5  
Old 06-01-2017, 02:20 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to filter email addresses on Excel ? Windows 7 64bit How to filter email addresses on Excel ? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by edinn10 View Post
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
__________________
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
Reply With Quote
  #6  
Old 06-01-2017, 08:49 AM
xor xor is offline How to filter email addresses on Excel ? Windows 10 How to filter email addresses on Excel ? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

@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.
Reply With Quote
  #7  
Old 06-01-2017, 09:15 AM
NoSparks NoSparks is offline How to filter email addresses on Excel ? Windows 7 64bit How to filter email addresses on Excel ? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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.
Reply With Quote
  #8  
Old 06-01-2017, 10:50 AM
NBVC's Avatar
NBVC NBVC is offline How to filter email addresses on Excel ? Windows 7 64bit How to filter email addresses on Excel ? Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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....
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to filter email addresses on Excel ? need to extract email addresses from excel files dunndealpr Excel 3 06-07-2013 08:29 AM
How to filter email addresses on Excel ? Incorrect Email Addresses StuartDAB Outlook 1 03-04-2011 07:01 PM
How to filter email addresses on Excel ? Duplicate Email Addresses lh66 Outlook 2 02-20-2011 07:32 PM
How to filter email addresses on Excel ? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft