Lukket

Cleansing a database of companies from duplicates and inconsistencies

We need to mark errors on a list of 5100 companies for review. This includes companies that appear more than once with variations of name and companies that do not fit the naming convention.

For every line in file, search to see if the name in column B (Account Name) appears again in other lines with variation. If true, mark "Yes" on column D and write in column E the name it appeared with first. If false, check if the name has the word " - Parent" as an appendage in the end. If not, mark "Yes" in column F.

For example -

The company in line 6 "Cisco" has a duplicate in line 4861 where its written as "Cisco Systems Inc." and in line 4880 where its listed as "Cisco France". For these 3 and any other duplications, you would mark "Yes" in column D on the same line and in column E write "Cisco".

For the company in line 2 "Wells Fargo Bank" there appears to be no duplicates but the name does not have the word "- Parent" appended at the end. In this case you will mark "Yes"

Evner: Dataindførsel, Excel, Word

Se mere: finding duplicates in hubspot, data cleansing strategy, data cleaning steps in data science, what is data cleaning in research, data cleaning machine learning, importance of data cleaning, data cleansing, data cleansing steps, oracle database companies nigeria, access database companies, database companies logos, database companies looking data entry workers, access database companies name, database companies dubai, mail database companies usa, forum database companies email telephone, list secondary database companies, database companies usa, best database companies, database companies dubai list

Om arbejdsgiveren:
( 0 bedømmelser ) Providence, United States

Projekt ID: #19715229

41 freelancere byder i gennemsnit $145 på dette job

TypingxpertRehan

i did similar work in the past and i have few ideas of how to get this done quickly and more accurtely, since names will be confusing, can we talk thx

$300 USD in 7 dage
(1405 bedømmelser)
9.1
jeweljitu

Dear Employer, i will verify each company information manually 1 by 1. This a manual process. i need total 5 days to complete the [login to view URL] sure are you save that time?. I am highly interested in your projec Flere

$250 USD in 5 dage
(1254 bedømmelser)
8.7
Innovative116

Hi there. I am a full time spreadsheet formatting expert. Cleansing a database of about 5100 companies as explained will be done with 100% accuracy within 2 days of project awarding. I have years of experience and have Flere

$150 USD på 1 dag
(369 bedømmelser)
8.3
Webxpert4u

I am ready to clean and update your 5100 companies database in excel as requested. And also will Yes and no. Can you please send me whole DB file? Ready to do first 20 rows for sample. Lets chat. Thank You

$333 USD in 7 dage
(290 bedømmelser)
8.0
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Flere

$250 USD in 4 dage
(311 bedømmelser)
7.8
mirniyazuddin92

Hi there, I can do cleansing a database of companies from duplicates and inconsistencies. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$250 USD in 7 dage
(392 bedømmelser)
7.9
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel sheet checked for duplicates and add some data if a duplicate is found. Flere

$100 USD in 2 dage
(195 bedømmelser)
7.2
BithiXpert

Hello Dear, I am an expert in Data Entry, Excel, Word and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high Flere

$250 USD in 5 dage
(308 bedømmelser)
7.2
TonmoyRoy111

Dear Client, I ensure I will complete the task successfully and within the specified time. I love perfection in work. So I ensure the work will be spot on. Your satisfaction is my success. Kindly contact me. Roy

$120 USD in 2 dage
(314 bedømmelser)
6.8
bd100m

Hi, send me the list. I can start now. I will deliver in 3-4 days. I understand the process. Thanks

$300 USD in 5 dage
(127 bedømmelser)
6.8
facebooklikes007

Hi, After reviewing the details of your project, I understood and highly interested in your project. I am guaranteeing you that you will get 100% satisfactory result. Please send us the details to do a Sample Work Flere

$150 USD in 4 dage
(126 bedømmelser)
6.5
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... https Flere

$140 USD in 7 dage
(80 bedømmelser)
6.5
dvcontact

Hi, Reading your project description about cleaning your Excel database makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Rather than just show you past similar projects Flere

$150 USD in 4 dage
(47 bedømmelser)
6.3
hdlan

Hello, I can identify and mark if companies that appear more than once with variations of name and companies that do not fit the naming convention. Let’s discuss if you’re interested. Best regards, Duong

$200 USD in 4 dage
(34 bedømmelser)
6.3
Rajni0802

Hi Client, I can manage this task of cleansing a database of companies from duplicates and inconsistencies as instructed and as per your requirement. Let's discuss further. - I can manage lead generation, web resear Flere

$250 USD in 5 dage
(101 bedømmelser)
6.1
younus15

I can do your project according to your description (5100 companies) with full delivery and without error. I would also complete your project with the highest precision and quality. I have extensive experience in Exc Flere

$200 USD in 7 dage
(104 bedømmelser)
5.9
andriphone0

Hello there, I'm interested in your project. I have a few questions about your project Please send me a message so that we can discuss more. Regards Ramveer

$150 USD in 3 dage
(74 bedømmelser)
5.8
c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for this project. Please send me a message and we can discuss further.

$30 USD in 7 dage
(50 bedømmelser)
5.5
nvchien94

Hello there, I am an Excel expert and I can clean database for you. I am very skilled at Excel and can create some macro to do it then check again. It helps increase speed. Please contact me. I can start right now and Flere

$100 USD in 2 dage
(78 bedømmelser)
5.2
ilenne217

Hi, this is Ilenne. I am interested to work on this project. If you need help with Data Entry work, I might be able to help you. I have years of experience doing Data Entry and I can work with quality and accuracy. I c Flere

$100 USD in 3 dage
(8 bedømmelser)
4.3