Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .