Probíhá

Excel Macro to Clean Company Names

We are looking for someone to aid with cleaning company names in a database that contains approximately 45,000 unique company names. We have identified several rules that we would like to be able to apply to the work.

To provide some context, we would be looking for someone to help clean up our marketing database.

At present we have carried out any company name standardisation by a large vlookup table. Any new raw names are first checked against this to see if we have come across them previously. If not, we then try to apply fuzzy logic to assign them to previously identified company names. Thirdly, if we still cannot identify them, we will highlight the blanks, sort the company names a-z and assign them manually.

One of the major problems we have identified is the lack of pre-assigned rules and several different people undertaking the cleaning process. Consequently, people have applied their own logic to the cleaning process, meaning that we often have been left with multiple derivatives of the same company name – this will have a negative impact on our marketing processes.

We have identified this as a suitable time to try and undertake a major clean on the database and the process by which we assign the company names. At present, we are finding it difficult to identify whether there is any automated process (such as a macro) which we could utilise to minimise the amount of manual work within the team. Therefore, we'd like to freelance the problem to see if this is possible.

Attached are the rules we are looking to apply to the database, if this is possible. All company names would have to be identical to the point where a vlookup table would work.

Dovednosti: Zpracování dat, Excel, Excel Macros, Excel VBA

Zobrazit více: excel macro sort function, excel macro file names directory, data clean excel macro, extract company name from email address, add name to filter in excel, list of names in excel sheet, working with names in excel, how to make a name list in excel, normalizing company names, list of names in excel format, how to normalize names in excel, macro clean proper excel, excel merge company names different spreadsheets, excel macro return file names directory, excel macro list worksheet names sheet, excel macro getting company release date, excel macro clean numbers text, excel macro clean forma, excel macro list file names directory, excel macro clean defined formats

O zaměstnavateli:
( 0 recenzí ) Bournemouth, United Kingdom

Identifikační číslo projektu: #18008457

Uděleno uživateli:

paris2785

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with Další

£15 GBP / hodina
(154 recenzí)
6.8

41 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě £13/hod.

schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel Macro to Clean Company Names. I've delivered more than 400 + projects in the last 5 years and this makes me very confident Další

£15 GBP / hodina
(283 Recenzí)
7.6
mirniyazuddin92

Hi there, I can create excel macro to clean company names. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

£10 GBP / hodina
(292 Recenzí)
7.7
SBITServices

Hello Alex, I have read your project description and i will write a Macro as per your predefined rules to clean the database. I never ask for payments in front. You can release the agreed milestones once Další

£10 GBP / hodina
(386 Recenzí)
7.3
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Další

£20 GBP / hodina
(171 Recenzí)
6.6
TonmoyRoy111

Dear client I would like to discuss with you about your requirements. Kindly contact me for further details and discussion. Roy

£16 GBP / hodina
(274 Recenzí)
6.5
Nidhijain123

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in ge Další

£13 GBP / hodina
(93 Recenzí)
6.0
kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/keviv Další

£10 GBP / hodina
(70 Recenzí)
5.7
£11 GBP / hodina
(56 Recenzí)
5.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Willing to take up your project. Thank you, Regards.

£15 GBP / hodina
(64 Recenzí)
5.7
pm9887

Hello, I can assist you in best way, I have good experience in many type of jobs. I am good in internet research and spreadsheet task. Would like to do some samples to gain your confidence. Let's initiate chat and dis Další

£10 GBP / hodina
(37 Recenzí)
5.0
prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv Další

£16 GBP / hodina
(51 Recenzí)
4.6
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of cleaning the database and manipulating strings. I have done mostly Ex Další

£10 GBP / hodina
(49 Recenzí)
4.8
supergana

Hi - I am an IT professional with 2 decades of experience. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple e Další

£13 GBP / hodina
(23 Recenzí)
4.5
backofficeworks

Hi, I think you just found the right candidate here! I will make sure to deliver the best as per your Requirements. I am an experienced content writer, web researcher, web scraper, internet marketer, Link builder and d Další

£10 GBP / hodina
(16 Recenzí)
4.3
prasannjeetp

Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.

£11 GBP / hodina
(36 Recenzí)
4.2
dataexplorer

"Hello Dear, Happy to inform you that I'm an efficient Web Researcher and Data Entry Worker. I've reviewed you project current project. I am able to visit the Organization’s website and research them. After all that Další

£11 GBP / hodina
(14 Recenzí)
3.4
rfreelancer2008

Dear sir/madam - Thanks for posting the project and also posting the details to such a low level, appreciate it very much. Please see my responses below with comments or questions, please note that they are marked Další

£16 GBP / hodina
(10 Recenzí)
3.2
krishnaagr89

Hi,I have read your requirements of Excel Macro to Clean Company Names and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss furth Další

£12 GBP / hodina
(4 Recenzí)
3.0
clearatul0

I have a good experience in VBA Automation and Excel formulas. I can also do dashboarding and problem solving using excel. I have also worked with marketing for lead generation using web scraping.

£11 GBP / hodina
(2 Recenzí)
2.6
egafiori

y name is Esteban, I'm an industrial engineer and Excel/VBA Expert. I'm new freelance,You can see some of my experiences in my profile. I could also help in economic analysis and evaluations, based on regression Další

£10 GBP / hodina
(6 Recenzí)
2.2