Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet that looks something like this:

Full Name    |      Email          |      Phone Number
---------          -------               -----------
Billy Bob          8019929102
Sally Sue          8013439403
Billy Bob                                 8013432343
Sally Sue
Joe So   

I want to remove duplicates based on email and keep the row that has the most complete data (the most columns filled). After I do email i'll look for duplicates based on Full Name and then phone number etc..

This is going to be done on almost 500,000 rows of data.

share|improve this question
Would it be viable to export the file into a CSV and parse it with a tool other than Excel? – rink.attendant.6 Aug 20 '13 at 4:25
I suppose so yes – Talon Aug 20 '13 at 4:41
which Phone Number is correct for Billy Bob?!? – Aprillion Aug 20 '13 at 16:44
In this scenario it doesn't matter, either one is just as likely to be correct. The only thing to worry about is which row has the most data. – Talon Aug 20 '13 at 19:14

Add a helper column that counts the number of fields. Then you can highlight dups.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.