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.
This project was awarded to
I have made several projects using GAF. I will try to keep IndoFreelancer in my "team" as long as I can, becouse he made all in time and also suggested many new features to script. He also made those without asking more money. It is rare that project like this, freelancer does all jobs without trying to go as easy as he can. IndoFreelancer did everything and more. Maybe best coder I have ever seen! Jani Finland
19 years programming and database experiences. 14 years web programming experiences.
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
Well, currently, I'm doing Masters of Business Administration (MBA) with dual specialization in Information Technology & Operations Management. And I have a team of professional Data Entry Operators (Team Size 10 Data Entry Operators). We are expert in all types of Manual Data Entry and Data Processing Work, Product Entry and Editing Work, PDF to Excel data conversion work and Virtual Assistant. Also, we are very well known in software tools like SAP, CRM, ERP, SPSS, Quickbooks, AppFolio, Adobe Dreamweaver, Adobe Photoshop, Adobe After Affects, Adobe Premiere, Autodesk Maya, Autodesk Max, Rayfire, Fumefx, RealFlow, etc etc "Customer Satisfaction Is What We Want To Deliver Every Time" We are available all days for work :) You can "Hire US" directly using our Freelancer profile. Have a Great day!
Worked with Kenya national bureau of statistics from 2006 to 2009. Started as a data entry officer involving various research work then advanced to be a research and data analyst. From 2009 to 2010 worked with UNICEF KENYA (United Nations International Children Emergency Fund) in contractual research work. About 3 years experience in technical and creative writing extending from research work to article writing and other related stuff.
@rostradamous: This employer tried to scam me and I had to do one more step to not lose fee and what I have done for him
Licenced Architect Member: COUNCIL OF ARCHITECTURE, INDIA.