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.
19 freelancers are bidding on average $27 for this job
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,
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.
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.
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