0

I have a spreadsheet that looks something like this:

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

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.

4
  • 2
    Would it be viable to export the file into a CSV and parse it with a tool other than Excel? Aug 20, 2013 at 4:25
  • I suppose so yes
    – Talon
    Aug 20, 2013 at 4:41
  • which Phone Number is correct for Billy Bob?!?
    – Aprillion
    Aug 20, 2013 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, 2013 at 19:14

1 Answer 1

0

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

You must log in to answer this question.

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