Excel Eliminate Partial Matches/Duplicates

Completed Posted 2 years ago Paid on delivery
Completed Paid on delivery

I have two long columns of company names in Microsoft Excel (XLSX).

Column A - new data

Column B - existing data

I want to remove duplicates and produce a new Column C of company names that are from column A but NOT in Column B.

however, companies are not 100% match (some include the word "INC" or "SRL" etc)- so we are looking for a macro or filter that would remove if the first XX (say 10) characters are a match?

Can that be set and figured out?

Sample file available.

Excel Data Processing Visual Basic Microsoft Office Excel Macros

Project ID: #32732951

About the project

39 proposals Remote project Active 2 years ago

Awarded to:

(453 Reviews)
7.8

39 freelancers are bidding on average $29 for this job

daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power More

$20 USD in 1 day
(217 Reviews)
7.2
shifa1988

hello, I am an expert in Excel formula. I understand your project requirements. it's duplicate checking new list with existing list. and making a new fresh column. let me show you my expertness. give me your file pl More

$20 USD in 1 day
(67 Reviews)
6.0
AAGGMM

Hello sir I am Ahmed, a data analytic with very good skills in spreadsheets [(Google sheets and Excel); including advanced formula, macros, power query and pivot tables], SQL and R-Programming language, also in data p More

$20 USD in 1 day
(100 Reviews)
5.6
mhfsha

Hello sir/ madam I checked your project description. I can do Microsoft Excel task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss more. Thank you. Regards, Saan More

$20 USD in 1 day
(137 Reviews)
5.6
vw1514518vw

Hello, "YES" that can be done and I'm ready to create the macro/script to do the required job, the macro will compare first few characters from company name from old and new data to spot matches and create unique rec More

$30 USD in 1 day
(17 Reviews)
4.3
srikanta0211

sir i can remove your data with more perfection. i will do it by a simple macro. and i will also explain you and give you that macro after doin your project. and this will take maximum 10min time.

$10 USD in 1 day
(19 Reviews)
3.6
Mslvirtualtask

Can we discuss in detail before hiring? I am a Virtual assistant. I also do data entry work at Microsoft Office. My services are ✓ Typing ✓ Copy Typing ✓ Data Extraction ✓ Data Scraping ✓ Data Entry on MS Word and Goo More

$30 USD in 2 days
(3 Reviews)
2.0
andylawsonstatz

Hello, sir! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. All clients call me "Prince of Excel". I promise I More

$30 USD in 1 day
(3 Reviews)
1.7
umar289

Hi, Yes, I CAN do this task. So, I have to write unique results that are from column A to new column which is column C and yes I understand that companies names do not match exactly like for example: 'Facebook' should More

$15 USD in 3 days
(3 Reviews)
1.5
Youssef262

I have seen your project and we can do it professionally What distinguishes my service is the speed in completing the work I am glad you contacted me

$20 USD in 7 days
(0 Reviews)
0.0
amujeeb

We can provide you what is required here. Dedupe data, merge or group the results In a way that you can see them separately. Using advance technical regex function we can eliminate or dodge the suffix or prefix.

$250 USD in 7 days
(0 Reviews)
0.0
mahc0220

Management of computer tools. Information processing and analysis capacity Structure, give content and meaning to texts Ability to make sense of texts, to avoid documents that are not useful Generate structured data Sp More

$30 USD in 7 days
(0 Reviews)
0.0
tridevdhungana

Hello! I am qualified Chartered Accountant having knowledge in field of Accounting, excel, Payroll, Financial statement etc. As I am good at excel, I can perform the same task easily and deliver the same to you on tim More

$20 USD in 1 day
(0 Reviews)
0.0
someshkarn1

Sure it can be done. I had solved this problem in past. Provide me opportunity to do this for you. Regards, Somesh

$20 USD in 5 days
(0 Reviews)
0.0
Sarojrajmaharana

Hello, My name is Saroj Maharana. I am writing to you for the position of data entry expert that you are looking for an urgent basis. have 6+ years of experiences in IT industry and that makes me confident to apply i More

$35 USD in 7 days
(0 Reviews)
0.0
rramkt

Hi, The solution can be a combination of either : 1. formula (to match first xx characters only) + quick manual filtering to check names 2. few sets of formulas to ignore words like LIC, SRC, .. and then compare the na More

$25 USD in 3 days
(0 Reviews)
0.0
AJebril

Hello there, I can help with the project posted, as I have years of experience in Data Processing, Excel and I will be glad to offer my expertise to deliver perfect work. Send me details please and I am ready to start More

$10 USD in 4 days
(0 Reviews)
0.0
kranupam24

Hi there I have read your requirements and I found myself eligible for that. I have experienced in this field and give my best to satisfy you. I am very lucky if you give me a chance to prove my skills. For more deta More

$10 USD in 7 days
(0 Reviews)
0.0
meyacharmaine07

I am very comfortable in using both Microsoft Word and Excel. I will work hard and make sure to deliver the results needed. Would like to apply for this project, hope you can give me the chance.

$10 USD in 7 days
(0 Reviews)
0.0
hafsaaziz09

Hi i have professional experience with Excel I read the description its a pretty straightforward job. I can do this for you in less time. Please reach out with more details

$20 USD in 1 day
(0 Reviews)
0.0