Remove duplicates from Excel file

IN PROGRESS
Bids
83
Avg Bid (USD)
$86
Project Budget (USD)
$30 - $250

Project Description:
I have a large list of companies in excel format.

There are many duplicate records - the record with the most information (address,phone, email, website url, etc. ) must remain. The record with the least amount of information should be deleted.

Please see attached file for examples. (duplicates have been highlighted in yellow and marked as "KEEP" or "DELETE".) Please understand the examples. This is how I want the duplicates filtered.

This project must be completed manually. DO NOT use the "Remove Duplicates" feature in Excel - removing the record is based on the amount of information in the record.

There are 38,000 records. These records are specific to our company, they are a list of clients and customers on our mailing list.

Some of these customers have multiple locations.
DO NOT delete the records if the name is the same but the address is different.

This project must be completed in 4 days. This is an easy project, but it must be done correctly and accurately.

REMINDER - THIS MUST BE DONE MANUALLY OR WITH A VERY SPECIALIZED SCRIPT. WE NEED TO KEEP THE RECORDS WITH THE MOST AMOUNT OF CUSTOMER INFORMATION.

Skills required:
Data Entry, Data Processing, Excel, Research, Virtual Assistant
Additional Files: sample.xlsx
Hire ssDaytona
Project posted by:
ssDaytona United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 100
in 3 days
Hire nehasb
$ 125
in 4 days
$ 100
in 4 days
$ 130
in 3 days
Hire bharanisrihari
$ 150
in 4 days
$ 50
in 1 days
Hire RajHeartbeat
$ 100
in 4 days
$ 50
in 4 days
$ 30
in 0 days
$ 100
in 4 days