0

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

pnuts
  • 6,072
  • 3
  • 28
  • 41

1 Answers1

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.

Jack
  • 181
  • 1
  • 6
  • Woot worked, thank you :] Well kinda. It deletes all the duplicate email addresses but not the entire row, and since it reorders the email addresses by default then it assigns the email address to the wrong rows which should have been deleted, any idea? –  Jun 13 '13 at 19:19
  • @HateNames Did you select all your data, or just the column with email addresses? –  Jun 13 '13 at 19:22
  • Ah I see...that did it, sorry for messing up when you gave me the correct answer from the beginning. Many thanks. –  Jun 13 '13 at 19:24
  • @HateNames No problem, glad it worked for you. –  Jun 13 '13 at 19:25