We have a list of 10.000 rows that is constanlty updating. So this must be done automatically in excel or php. It will take every row and compare it with all the others. then it will return the most similar results.
Those similar results will have some common text. This text must be returned in another column in order to match them.
Azzaro Chrome Eau De Toilette 100ml
Azzaro Chrome Eau De Toilette 100ml & 100ml Aftershave
Azzaro Chrome Eau De Toilette 100ml & 200ml Shower Gel
Azzaro Chrome Sport Eau De Toilette 100ml
Azzaro Chrome Sport Eau De Toilette 30ml
Azzaro Chrome Sport Shower Gel 50ml
Xpel Tea Tree 100% Pure Tea Tree Oil 10ml
Xpel Tea Tree 100% Pure Tea Tree Oil 30ml
Xpel Tea Tree Anti-bacterial Handwash 500ml
Xpel Tea Tree Facial Scrub 250ml
Xpel Tea Tree Foaming Face Wash 200ml
The manufacturer will be given in another column and it should be subtracted from the product name. for the examples above the manufactures are Azzaro and Xpel. So the final product names for similarity comparison will be
Chrome Eau De Toilette 100ml
Chrome Eau De Toilette 100ml & 100ml Aftershave
Chrome Eau De Toilette 100ml & 200ml Shower Gel
Chrome Sport Eau De Toilette 100ml
Chrome Sport Eau De Toilette 30ml
Chrome Sport Shower Gel 50ml
Tea Tree 100% Pure Tea Tree Oil 10ml
Tea Flower 100% Pure Tea Tree Oil 30ml
Tea Tree Anti-bacterial Handwash 500ml
Tea Tree Facial Scrub 250ml
Tea Tree Foaming Face Wash 200ml
We must get the most similar results for each row. Do not ask us how. If we knew how we would have done it ourselves. Similarity is the key word.
Some first thoughts is to order them by name and check word by word.
The similarity percentage will define which products should be matched. The 5 or 10 most similar will be matched and their common text will be the keyword so we can match them.
I read your bid, I can do this using Power pivot and some Macros. If you give me the job I can start it after 6PM Est time. January 11, 2017 Dear Hiring Manager I am 20 years old guy and live in Brazil Plus
44 freelance font une offre moyenne de €33 pour ce travail
>>>>>>>>>>>>>>>> Preferred freelancer here <<<<<<<<<<<<<<<<<<<<< Hi there – Saqib from Xtreme web tech. I’ve read your brief and can see that you’d like to. Compare a list of product names and return most similar Plus
please check my profile, i've no incomplete project we can perform this task in excel as well as PHP please share file, i'll show demo before you hire me i assure you, i'll complete this task as per your requiremen Plus
Aquaholix Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same Plus
Hello, I have gone through your outsourced requirements "Compare a list of product names and return most similar products" and have analyzed that I have right skills (Excel, PHP) to execute your esteemed project. Plus
Hello, Sir, I will send the quick sample. I will fill in a spreadsheet with data for you. I have using tactically use many things but Google for finding keyword relented companies, Email, address, Person name, phone, e Plus
Hi, I read carefully your project, and I wanna do it for you. If you wanna work together, send me a message to discuss details. I am an experienced Web Developer and Web Designer, and have worked with wide variety of s Plus
Hello, I am a professional software developer.. I have read your project requirement, and i solve your problem. I understand it and i have solution to for that too. I am free and can start immediately. Please contac Plus
My name is Lydia, I'm working on the computer last 15 years. My Top Skills Excel, Microsoft Office,Internet Research.
I have created many macros in Excel, I will be able to do this task. Would the first word be always the manufacturer? There may be more complications if the manufacturer,s name consists of two words. Any way let me hav Plus
Hi, Please consider us for this project and give us an opportunity to showcase our work to you. We can assure you on time we will deliver a bug free application . So we will discuss more on it in near future . B Plus
Greetings, I would like to submit my proposal for your project on Excel. I Understand the importance of this project due to my educational background and I will do this job with great care and responsibility. I am a Plus
Hi! Being attracted with your declaration of program, I feel tempted to have the chance to make your work complete carefully and sincerely. I would like at present to have your kind-mind and as soon as possible. S Plus