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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete row if blank in a column 5
Find Mismatched Data 5
help with formula 13
Extract email(s) from address field 3
Extract emails from cells with text 4
copy data for match word from one file to another file 1
counting blank cells within two columns 2
Combine Records; Difficult 3

Back
Top