Match two columns in Excel for duplicates and similarities

Cerrado Publicado hace 4 años Pagado a la entrega
Cerrado Pagado a la entrega

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.

Excel Procesamiento de datos Programación en C# Visual Basic Excel VBA

Nº del proyecto: #22209637

Sobre el proyecto

37 propuestas Proyecto remoto Activo hace 4 años

37 freelancers están ofertando un promedio de $26 por este trabajo

P0L

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.

$50 USD en 1 día
(359 comentarios)
7.5
asadkhan3533

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

$30 USD en 1 día
(187 comentarios)
6.8
elqueabandona

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 Más

$30 USD en 1 día
(243 comentarios)
6.9
masud0012

I am ready to start right now.I am a full time dedicated freelancer. Dear Hiring Manager, I have read your job description carefully and I’m very considering your job such as these capabilities. I have fantastic expe Más

$10 USD en 1 día
(123 comentarios)
6.1
c4cuteconain

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 Más

$20 USD en 7 días
(82 comentarios)
5.9
akritisood94

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 Más

$20 USD en 7 días
(74 comentarios)
5.4
sonarkaushik

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

$29 USD en 2 días
(54 comentarios)
5.8
writingapp

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 Más

$30 USD en 1 día
(40 comentarios)
5.1
mostafawalker

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

$35 USD en 3 días
(18 comentarios)
4.9
jsb1156

Experienced project professional, MBA, EXCEL and MS Project expert; strong estimating background, experienced with complex formulas, LOOKUPS, PIVOTS, and charts towards the delivery financial analytics. I currently wo Más

$20 USD en 3 días
(27 comentarios)
4.3
gjursch

Hi, I am an excel expert in the US. I can do this for you. I am an expert in data manipulation. All of your examples can be handled with a formula. Basically, if you can define the rules I can implement it. If it Más

$50 USD en 7 días
(2 comentarios)
4.5
haleem0786

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

$30 USD en 2 días
(25 comentarios)
4.0
tutulsoft

--- READY TO DO ----------- understood all of your documentation ---------------i am online now ----------- EXCEL VBA and Excel Function Expert

$30 USD en 7 días
(3 comentarios)
4.0
MonisZafar

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.

$30 USD en 1 día
(13 comentarios)
4.2
reubengi

Hi, I can get the formulas to do this comparison. Are you trying to find the comparison for the data in Col B from the list in Col A or the other way around? Your description is like the company names you want to compa Más

$20 USD en 1 día
(10 comentarios)
4.0
IshaqKN

Hi there, Your probably may need me. What you want in "D" is called fuzzy search. For which I can create my own algorithm or use difflib library. I am expert in data processing + regex. I will deliver standalone GUI Más

$25 USD en 2 días
(12 comentarios)
3.9
Sarmistha99

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 Más

$30 USD en 1 día
(8 comentarios)
3.9
engelnady

GO WITH SCIENCE AND EXPERIENCE. I'm a Master holder in computer science and a data processing expert for 10+ years. I'm an expert who pays attention to details and appreciate the value of time so the project will be d Más

$20 USD en 1 día
(6 comentarios)
3.2
Prompty

Hi, i am expert in data massaging. I do write scripts to handle data massaging. I got idea to work on the problem. I will deliver a tool or a macro , which will solve this problem. In the past i had developed many data Más

$30 USD en 3 días
(4 comentarios)
1.9
FuadSahinovic

Hello, could you please provide me the excel? I have done this numerous times and should be no problem. Best regards Fuad

$30 USD en 2 días
(1 comentario)
1.0