Remove duplicates from Excel file

In Progress

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: Data Entry, Data Processing, Excel, Research, Virtual Assistant

See more: we excel, excel based companies, customer data in excel, remove, remove from, how to remove phone, format excel, excel format, excel duplicate, excel based, delete duplicate, multiple excel, excel mailing, excel specific, duplicates excel, need excel format, excel record, excel address phone list, remove script, email excel file, large file, duplicate file, record excel, file name excel, format file

Project ID: #1063818

Awarded to:

IndoFreelancer

Please check PM, Thanks.

$35 USD in 3 days
(2 Reviews)
2.6

83 freelancers are bidding on average $86 for this job

pandeypriya2003

Hello, GAF 10th rank provider here at your service. We have a team of Data entry experts which completed more then 1000 projects and provided excellent result. Please check inbox for detail. Thanks Preeti

$100 USD in 3 days
(542 Reviews)
7.5
nehasb

Please view my PMB.

$125 USD in 4 days
(348 Reviews)
6.8
BDspeed

**PLS CHECK PMB**

$100 USD in 4 days
(240 Reviews)
6.5
Kamalkishover

Pls Check PM

$130 USD in 3 days
(213 Reviews)
6.6
bharanisrihari

Hello, Excel VBA expert here. I've done similar project successfully. Please check PM for details. Thanks!

$150 USD in 4 days
(59 Reviews)
6.3
YourAssistant

{{(((Please read PM for further details)))}} …Thanks

$50 USD in 1 day
(101 Reviews)
6.1
RajHeartbeat

Hello sir, I'm ready to start. I will work until you get 101% satisfaction. Please refer to the PMB for further details..!

$100 USD in 4 days
(55 Reviews)
5.7
experttwitter

Lets Start Sir..

$50 USD in 4 days
(9 Reviews)
5.6
ineedWorkJob

sir plz check pm !

$30 USD in 0 days
(39 Reviews)
5.1
nashid1234

{+++ready to start right now..please check pm+++++

$100 USD in 4 days
(69 Reviews)
5.1
JovenR

Hi! I highly appreciate if you give me a change to handle the job, lets start the job.

$80 USD in 3 days
(24 Reviews)
4.8
amindulal

Hi, I am seriously want to do this job. Please check PM. Thanks

$120 USD in 7 days
(5 Reviews)
4.7
abbie3290

Please Check your PMB.

$60 USD in 4 days
(22 Reviews)
4.7
dobreiiita

Ready to start working.Check PM>

$50 USD in 1 day
(19 Reviews)
4.5
eelance

i can do that for you.

$130 USD in 3 days
(12 Reviews)
4.4
bluefox4ever

Dear Hiring Manager, I want to do this "Remove duplicates from Excel file" project now, let's start immediately. I have read the job description. Please send me the excel file Regards, Oliver

$30 USD in 1 day
(15 Reviews)
4.4
JJdatajobs

Hello"ssDaytona", Please check PM. Thank you. Regards.

$155 USD in 3 days
(22 Reviews)
4.3
telemarketing555

Hi, please check your PM. Thank you.

$129 USD in 2 days
(22 Reviews)
4.4
ExactSystems

Please see detail on PMB. regards

$45 USD in 4 days
(3 Reviews)
3.8
EmpUkbased

Lets start

$150 USD in 4 days
(5 Reviews)
3.8