Excel Eliminate Partial Matches/Duplicates
$10-30 USD
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.
Project ID: #32732951
About the project
Awarded to:
39 freelancers are bidding on average $29 for this job
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
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
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.
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
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
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
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.
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
Sure it can be done. I had solved this problem in past. Provide me opportunity to do this for you. Regards, Somesh
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
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
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.
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