I’m building a tool for users to check their own performance on QA/QC samples without revealing the true values to them (Tbl.Grp1.entry and Tbl.Grp2.entry). Right now I do this manually for each instance.
I’m getting stuck on how best to compare values when the TYPEs are mismatched, and when...
A simple fuzzymatch logic that can be placed in an access module. This is a UDF(User Defined Function), and can be called from a query to retrieve suitable results.
Variations can involve replacing special characters, vowels before matching so as to customise as per requirements.
Function...
I have data on rental prices for houses in the city of Mumbai. It contains approximately 12000 addresses, their coordinates, area, rental price and number of rooms.
In a separate file, I have 1000 addresses with a lot more variables (but they also have the coordinates, area, rental price and...
I have two sheets in Excel 2013: One contains more than 200 Brandnames, plus their importance on an increasing scale starting at 1, plus a category. The second sheetcontains more than 13,000 keyword phrases, which may – or may not – contain the Brandnames in the first table.
What I want to do...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.