Use Advanced Filter to get the Unique records on Email address, then use
INDEX/MATCH combination to get Names
"Outlook, eh?" wrote:
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
Susie
Peter
Should be
A B
Joe
Peter
Thanks so much!
-B