Two columns only take one name for both email address

  • Thread starter Thread starter Outlook, eh?
  • Start date Start date
O

Outlook, eh?

I have 40,000+ record file and would like to get rid of one row (name & email
address) if it shares an email address:

For Example:
A B
Joe (e-mail address removed)
Susie (e-mail address removed)
Peter (e-mail address removed)

Should be
A B
Joe (e-mail address removed)
Peter (e-mail address removed)

Thanks so much!
-B
 
Use Advanced Filter to get the Unique records on Email address, then use
INDEX/MATCH combination to get Names
 
Amazing! I believe it matched names without me having to do anything more
than filter on unique names. Thanks!
 
Back
Top