Closed

Create a Code for Excel to Find the Best Partial Match - Repost - repost

I have an Excel spreadsheet with a column containing names with typos (misspelled names) and another column containing the correct names. I need a code to insert next to the cell with the misspelled name the correct name pulled from the “Correct Names” Column.

For example, if in the “Names with Typos” column have the cell “Michaelsx” and in the “Correct Names” column have the cell “Michael”, I need the column “Best Partial Match”, which is next to the column “Names with Typos”, to be populated with “Michael” right next to the cell “Michaelsx”. If no reasonable partial match can be found the cell next to the misspelled name will be empty.

I attached a sample spreadsheet with the work done by me in a visual way. Now I need an intelligent code to do this job automatically so I can use it in another spreadsheets. The format of the other spreadsheets I will use will be the same, with the same columns, but with more data / rows. The column that the code will need to populate is the “Best Partial Match” column.

I will only pay when the work is correctly done and tested by me. The code cannot be done in a way that only works in this sample spreadsheet since my end goal is to use in another spreadsheets.

Skills: Data Entry, Data Processing, Excel

See more: works need excel, the best job to have, the best job, ok job match, find works, find work now, find the right job for me, find the right job, find the job for me, find the job, find a job now, best way to find a job, best excel spreadsheets, best code, i need a job right now, find my name, cannot find a job, best way to find job, excel to, create a excel, excel best match, populate excel spreadsheet spreadsheet, excel format cell, excel cell format, excel 2013 visual

About the Employer:
( 0 reviews ) Marikina City, Philippines

Project ID: #4994639

19 freelancers are bidding on average $27 for this job

expertatwork

Hey joycepascual, please share the sheet. it is not attached here... meanwhile - are you using MAC or WINDOWs ?

$30 USD in 2 days
(39 Reviews)
4.4
deatc

Hi, Joyce. Please consider me for this project. Could I please get a copy of the worksheet? Thank you.

$25 USD in 3 days
(12 Reviews)
3.3
tomislav1975

If you want A+ VBA & Excel expert, search no more. I'm here, you can award me with trust. If you have doubts check my reviews and 100% Repeat Hire Rate. With regards,

$26 USD in 1 day
(3 Reviews)
3.1
zExcel

Normally excel (or any program for that matter) cannot do partial searches unless there is a certain logic for what is considered a partial match (the letter "e" can be a found as partial match between almost all the e More

$19 USD in 1 day
(1 Review)
2.0
danaldea

Hello, I think I've bid on this project before and I've explained my proposed approach (introducing a variable which would determine the accuracy of the search - from 0=inaccurate to 100=exact match) so that you can More

$55 USD in 3 days
(3 Reviews)
2.0
samintu

Dear Sir, Thank you very much for this Nice Job. I have Experienced in different Categories of Data entry. Any type of Data entry Any type of Research I'm expert in MS Excel, Word, Article Submission, Press R More

$25 USD in 3 days
(10 Reviews)
1.6
saktulgasaktulga

Hello, I am an excel expert who can do this project in a very short time. I thinki I qualify for the project with my enhanced excel experience. Regards.

$25 USD in 3 days
(0 Reviews)
0.0
aicsitg

I will preface my proposal by saying that I was just able to successfully implement the code you requested after reading the description. It's available to be sent immediately upon selection of my bid. Please don't l More

$10 USD in 1 day
(0 Reviews)
0.0
himanshu78goel

Hi, I am very much interested in this project and i am having professional background. Please check my profile... Thanks

$55 USD in 30 days
(0 Reviews)
0.0
jhaymz02

Hi, Kababayan Joyce I found your Create a Code for Excel to Find the Best Partial Match Project Post and I am Interested on it. I am currently working as Data Control Supervisor at Highland Banana Corporation, Da More

$12 USD in 3 days
(0 Reviews)
0.0
Hemanga

I'll do it for you clean and clear before the time mentioned by you. Please message me more details so that I can start the project ASAP. :)

$10 USD in 3 days
(0 Reviews)
0.0
mazmdm

I'm biostatistician : 5th year of university in agronomy + 5th year of university in statistical methodes. I'm ready to do your sheet. Well-off with manipulations on Excel and Internet, it will be easy for me to create More

$35 USD in 3 days
(0 Reviews)
0.0
Mathumet

Hi, I have experienced in Excel and Data entry and Proficiency English Typing level, And delivering prompt time and quality also good. And I'll accept u r offering. Once u satisfied my work after that provide my More

$15 USD in 2 days
(0 Reviews)
0.0
leninlenin007

i can do this for u better than anyone else .still i m new to freelancer i m ned of a job and i request you to provide me this to make a improvement in me as to better me up

$26 USD in 3 days
(0 Reviews)
0.0
avd369

This is a very simple project and could be solved easily with Macros. I have worked in advanced excel to solve these issues for more than 15 years. If this project is awarded to me I will deliver the same in 2 da More

$30 USD in 3 days
(0 Reviews)
0.0
geetesh16

I can do this for sure.....................................................................................................

$25 USD in 3 days
(0 Reviews)
0.0
gazisoriful

Dear sir I have good knowledge of data entry, microsoft excel spreadsheet, PDF, internet search & web search. Please give me this opportunities. I hope you are pleased my work. Thank you.

$25 USD in 3 days
(0 Reviews)
0.0
AbhilashMishra

Hello, I can make a software for you which can do your work perfectly. You just have to select the target file and it will do the rest. I could not find the attached spreadsheet . Please send it to me and i will creat More

$45 USD in 2 days
(0 Reviews)
0.0
joreb

Hi, I have extensive experience working with excels, especially in the banking industry, and I've come across & tackled this situation while managing large quantities of data; to find a string within a string. I have More

$20 USD in 1 day
(0 Reviews)
0.0