Excel - VLookup - Cleanup

$8-15 USD / hour

Ukończony

Opublikowano

ponad 2 lata temu

$8-15 USD / hour

I have two Excel sheets. I am using the company name field from both sheets to match using VLookup and populate an ID field. Most matching is done but there are differences in some company names which effect the accuracy. I need this cleaned up so all possible matching is complete. This means normalizing the company names on both sheets so they match exactly. There will be duplicate names occasionally and the most complete name will survive the edit process and be matched. Please provide a cost and delivery estimate in your response.

Identyfikator projektu: 32796537

Informację o projekcie

20 ofert

Zdalny projekt

Aktywny 2 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@AnowarRatul

$0 USD w 40 dni

5,0

(366 opinii)

6,7

20 freelancerzy składają oferty o średniej wysokości $12 USD/godz. dla tej pracy

@uumarkhalid31

Hi I am expert in excel and i have full command on vlookup or normalizing the data. contact me and lets discuss the job with perfection and accuracy regards Umar

$12 USD w 20 dni

4,9

(219 opinii)

7,0

@charleslimnet

Hello I am a proficient EXCEL VLOOKUP expert in business and finance analysis. I have 18 years’ experience as a practicing CPA and 20 years’ experience as an academic researcher and analyst. I am passionate about this project having gone through the instructions. I have 520+ reviews on related projects and the responses are positively overwhelming. I hold an MBA (Strategic Management), Bachelors of Commerce (Finance and Accounting) & C.P.A. (Certified Public Accountant.) Regards, Charles.

$15 USD w 40 dni

4,8

(85 opinii)

6,3

@konanhenry1111

2 hours = 50$ ⭐⭐⭐⭐⭐⭐I am an engineer and I read the details accurately.⭐⭐⭐⭐⭐⭐ I am ready to start now. Just if u have more details or questions u can ask me in chat. Check my projects that I have finished related to engineering in my profile. Let us discuss in chat. "

$12 USD w 40 dni

5,0

(57 opinii)

5,5

@PERPETUAL0

Hello there its not take more than hour regard s ILYAS

$12 USD w 40 dni

4,8

(96 opinii)

5,4

@utkarsh7238

Hello, I can clean up your 2 Excel sheets with VLookup In how much time you want it to be completed? Let's talk about your Project Waiting for your Response!!

$8 USD w 40 dni

4,9

(35 opinii)

4,8

@Peefect

Hi, After checking file I have found I can do it with in 20 to 30 min only . Thanks.(Note-I am an expert and I am waiting please reply fast)

$8 USD w 40 dni

4,9

(34 opinii)

4,3

@MamukaB

Good Morning I'm doing reports using excel VBA from big data bases So, it's easy job for me. I think I can do the project , but need some more detailed clarifications from you I have 15+ year experience with Excel VBA So you can trust to me. Result will be excellent Thanks

$8 USD w 40 dni

5,0

(10 opinii)

3,5

@rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul

$12 USD w 40 dni

5,0

(7 opinii)

2,6

@kamranbashir2020

Hi! I am a data entry expert . I am ready to start right away. Let's talk over the chat to discuss further. Thank you!

$9 USD w 40 dni

5,0

(2 opinii)

1,8

@tefoai

Hi, could you please give an example? Like for example you have rows like McKinsey and Mc-Kinsey, which are same but in terms of letters they are not. And you want me to fix all of these, right? If so, I can do it for 40$ in whole dataset.

$8 USD w 40 dni

5,0

(1 opinia)

1,3

@payalku40

HhI I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy

$12 USD w 40 dni

0,0

(0 opinii)

0,0

@gracew20

Hello, I am Grace ,your data analyst professional in the following areas, with 4 years experience ≥macros ≥VBA ≥pivot tables ,power query,charts and dashboards with slicers and timeline ≥Automation of sheets with formulas ≥Data filtering, sorting, vlookups and data validation ≥statistical data analysis in excel ≥Consolidation of excel reports

$12 USD w 40 dni

0,0

(0 opinii)

0,0

@Roshan876

I can arrange all your missed placed names on your sheet, on time and accurate. You won’t have anymore problems with the accuracy of your work.

$13 USD w 40 dni

0,0

(0 opinii)

0,0

@MuhammadAdil17

Hello dear, Hope you are doing well Please contact that i can help you in in this issue you will not get any inaccuracy after i assist you I can do it in a few minutes. I am at your service please contact. Thanks

$10 USD w 2 dni