fuzzy logic

  1. Asbestos_Jen

    Compare multiple parameters of samples to reference values (Excel 2007)

    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...
  2. svkroy

    FuzzyMatch Function/Logic

    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...
  3. A

    Assign values from a range based on a criteria

    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...
  4. M

    Fuzzy Logic? Partial match to retrieve values from separate table

    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've detected that you are using an adblocker.

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.
Go back
Back
Top