You will get the closest approximate match and comparison of two different Excel columns
You will get the closest approximate match and comparison of two different Excel columns
Project details
Do you have datasets in two separate columns in Excel, same logically but different text composition? To get an approximate match using Hlookup, Vlookup etc won't give you the desired results because the string or text is not quite the same.
I will provide the matched data and the percentage of closeness.
Eg: You have the data below.
ABC company : TC203
XYZ Ventures : AB101
Textile Corp: XY203
And you need to achieve the below:
ABC company : AB101
XYZ Ventures : XY203
Textile Corp: TC203
Basically, an approximate match is what is more appropriate. Matching the two columns based on closeness of the text.
Manually doing so will cost you precious time. Allow me to apply automated means based on Microsoft Research tools. All that is needed is to have the data in Excel. This does not guarantee 100% accuracy as some text may present almost the same closeness.
Please note the number of Pages in the pricing refers to rows in Excel.
I will provide the matched data and the percentage of closeness.
Eg: You have the data below.
ABC company : TC203
XYZ Ventures : AB101
Textile Corp: XY203
And you need to achieve the below:
ABC company : AB101
XYZ Ventures : XY203
Textile Corp: TC203
Basically, an approximate match is what is more appropriate. Matching the two columns based on closeness of the text.
Manually doing so will cost you precious time. Allow me to apply automated means based on Microsoft Research tools. All that is needed is to have the data in Excel. This does not guarantee 100% accuracy as some text may present almost the same closeness.
Please note the number of Pages in the pricing refers to rows in Excel.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$50
|
Standard
$100
|
Advanced
$150
|
|---|---|---|---|
| Delivery Time | 3 days | 3 days | 3 days |
Number of Revisions | 1 | 1 | 1 |
Number of Pages Mined/Scraped | 10000 | 30000 | 50000 |
Frequently asked questions
About Zion
Proven Expert in Finance | Technology | Analysis | Business Operations
Leeds, United Kingdom - 7:21 am local time
I have handled product research, market and industry analysis, customer behaviour, Go to Market strategy, planning and helped formulate business strategy for numerous clients. I posses over 3 years cognizant experience of US and Europe business environment, and very current with the economic and socio-political events in both regions.
I have worked for top-tier institutions and gained valuable experience in Finance, Operations, Admin, Sales, Entrepreneurship and Business.
Currently I consult on Finance, Technology, Fintech, Business and Analytics to companies and teams wishing to leverage and improve their Business Operations and grow.
I am extremely good at what I do and keep getting better at it.
Steps for completing your project
After purchasing the project, send requirements so Zion can start the project.
Delivery time starts when Zion receives requirements from you.
Zion works on your project following the steps below.
Revisions may occur after the delivery date.
File
Please provide the file in Excel or spreadsheet format. There have to be two columns. Please specify the main column and the second column to be matched against it. The Excel file also have to be properly formatted before sending across.
Revision
I will provide the matched data and the percentage of closeness for your review. You may specify if the closeness percentage be increased or not. The higher the closeness percentage, the lower the text match.