Cross check email addresses and delete the entire row of duplicates?

Question

I need to merge 2 files into 1 and would like to crosscheck the email addresses to find duplicates and delete the entire row that it's contained in. Is this possible?

So far I just copy pasted all the data in one single sheet but each on a new page/worksheet but can't seem to find anything to do what I need. Any advice? Thanks in advance for any help

score 2 · Accepted Answer · answered Jun 13 '13 at 19:12

2

Assuming you are using Excel 2007 or 2010:

Select your data. Go to the Data tab -> Remove duplicates. Uncheck every column except the one that contains your emails, and press OK.

answered Jun 13 '13 at 19:12

Jack

181
1
6

Cross check email addresses and delete the entire row of duplicates?

1 Answers1

Linked