Suljettu

Match two columns in Excel for duplicates and similarities

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.

Taidot: Excel, tietojenkäsittely, C# -ohjelmointi, Visual Basic, Excel VBA

Näytä lisää: rearrange columns excel, convert columns excel columns rows, rearranging columns excel, excel find matching values in two worksheets, compare two columns in excel and return common values, excel match two columns and output third, compare two columns in excel for match, compare two columns in excel using vlookup, compare two columns in excel for differences, excel compare two lists and return differences, how to find duplicate values in two columns in excel using vlookup, convert rows columns excel, generate data based columns excel visual basic script, deleting columns excel visual basic, convert word doc columns excel, sum columns excel sum, excel macro freelance hourly rate, check excel sheets similarities, compare columns excel discrepancies, excel macro match columns sample

Tietoa työnantajasta:
( 5 arvostelua ) bakersfield, United States

Projektin tunnus: #22209637

38 freelanceria on tarjonnut keskimäärin 27$ tähän työhön

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Lisää

$50 USD 1 päivässä
(341 arvostelua)
8.0
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 1 päivässä
(335 arvostelua)
7.3
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 Lisää

$30 USD 1 päivässä
(234 arvostelua)
6.9
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, MS Word, Access, Outlook, Google Sheet, Access, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management ht Lisää

$30 USD 7 päivässä
(98 arvostelua)
6.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 1 päivässä
(162 arvostelua)
6.6
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 Lisää

$10 USD 1 päivässä
(122 arvostelua)
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 Lisää

$20 USD 7 päivässä
(71 arvostelua)
5.8
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 2 päivässä
(54 arvostelua)
5.8
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 Lisää

$20 USD 7 päivässä
(55 arvostelua)
5.3
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 3 päivässä
(14 arvostelua)
4.7
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 Lisää

$30 USD 1 päivässä
(25 arvostelua)
4.7
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 Lisää

$50 USD 7 päivässä
(2 arvostelua)
4.5
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 Lisää

$20 USD 3 päivässä
(24 arvostelua)
4.2
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 2 päivässä
(23 arvostelua)
4.0
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 Lisää

$20 USD 1 päivässä
(6 arvostelua)
3.1
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 1 päivässä
(6 arvostelua)
2.9
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 Lisää

$25 USD 2 päivässä
(4 arvostelua)
2.6
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 Lisää

$30 USD 1 päivässä
(1 arvostelu)
1.8
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 Lisää

$30 USD 3 päivässä
(4 arvostelua)
2.0
Alexsfodik

Hello. How are you. I'm software engineer and algorithm expert. I have many experiences in Access, Excel, VBA. I can complete your project successfully. Thanks.

$50 USD 1 päivässä
(1 arvostelu)
1.6