Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a spreadsheet that looks something like this:

Full Name    |      Email          |      Phone Number
---------          -------               -----------
Billy Bob          bob@gmail.com          8019929102
Sally Sue          sue@gmail.com          8013439403
Billy Bob                                 8013432343
                   bob@gmail.com
Sally Sue
Joe So             joe@gmail.com

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
2  
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

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

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.