Match two columns in Excel for duplicates and similarities
$10-30 USD
Paid on delivery
Hello, I am looking for an advanced Excel formula that will compare two lists of Company Names and find similarities between the two lists. I am not seeking simply a list comparison to identify duplicates, if I wanted to do that I could use any free online tool. I am seeking for a tool that will go beyond just identifying duplicates between the lists, including finding similarities.
Column A will have a list of thousands of company names
Column B will have a different list of hundreds (or thousands) of company names
Column C needs to generate exact duplicate values (if any) between Column "A" and "B"
Column D needs to generate similar values (when present) between Column "A" and "B"
For example, if company name called “UpWork” was in Column “A,” and if company name called “Up Work” was in Column “B,” it needs to identify it in Column D as a “similar value” — within Column D, it needs to display it in this format: UpWork, Up Work
Another example:
If company name “Microelectronics” was in Column “A” and “Micro Electronics” was in Column “B” it needs to identify it in column D as a “similar” value — within column D, it needs to display it in this format: Microelectronics, Micro Electronics, while Column C is blank.
Another example:
If company name “[login to view URL]” was in Column “A” and “Fenderstuff” was in Column “B” it needs to identify it in column D as a “similar” value — within column D, it needs to display it in this format: [login to view URL], Fenderstuff, while Column C is blank.
Another example:
If company name “Frys Electronics” was in Column “A” and “Fry’s Electronics” was in Column “B” it needs to identify it in column D as a “similar” value — within column D, it needs to display it in this format: Frys Electronics, Fry’s Electronics, while Column C is blank.
Another example:
If company name “Pureromance” was in Column “A” and “Pureromance” was in Column “B” it needs to identify it in column D as a “similar” value — within column C, it needs to identify it as a duplicate and write it in this format: Pureromance, while Column D is blank since there is no similarity in this case but rather an exact duplicate.
Another example:
If company name “Arbonne” was in Column “A” and “Arbonne LLC” was in Column “B” it needs to identify it in column D as a “similar” value — within column D, it needs to display it in this format: Arbonne, Arbonne LLC, while Column C is blank.
Another example:
If company name “Bestbuy, Inc.” was in Column “A” and “Best Buy” was in Column “B” it needs to identify it in column D as a “similar” value — within column D, it needs to display it in this format: Bestbuy,Inc., Best Buy, while Column C is blank.
Another example:
If company name “Chicken-Sandwich” was in Column “A” and “ChickenSandwich LLC” is in Column “B” it needs to identify it in column D as a “similar” value — within column D, it needs to display it in this format: Chicken-Sandwich, ChickenSandwich LLC, while Column C is blank.
Another example:
If “Cloud Sandwich” is in Column A and “Sandwich Cloud” is in Column B, no entry should be made in Column C or Column D
The end result is a tool that will allow me to compare two lists, and have a 99% accuracy rate in identifying similar values. Each company name can be spelled differently, i.e. with Inc, LLC at the end, or different spacing, and as such, it is prudent to have a tool that identifies not only exact duplicates, but also similarities in real-world use cases.
Be advised that it will be necessary to run this tool against live data multiple times to find where additional adjustments are needed (where the tool’s matching is too conservative, or too aggressive), therefore expect some follow-up requests for adjustments that will ensure your tool is useful to me in a real-world use case.
Project ID: #22209637
About the project
37 freelancers are bidding on average $26 for this job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss. Thanks, Asad Khan FixIT Consultancy
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje More
I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and I can start working on your proj More
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S More
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL More
I'm highly skilled c# programmer and desktop developer, I can help in finding similar words as you require in 2 columns with simple software I'll create , please contact me to discuss details and chat
i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks
--- READY TO DO ----------- understood all of your documentation ---------------i am online now ----------- EXCEL VBA and Excel Function Expert
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.
Hi, I am a data analyst with expertise in excel , VBA and different python packages. I have some ideas in mind to extract similar names. I would like try those out to see if it meets your requirement. Maybe we can More
Hello, could you please provide me the excel? I have done this numerous times and should be no problem. Best regards Fuad
