fuzzy

  1. 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...
  2. J

    Performing a "fuzzy" look-up by row

    Hi everyone I have a long spreadsheet with just 1 column (and around 8,000 rows) which has the names of Educational institutions in it. I would like to perform a fuzzy-type lookup on the data to see if there are any similarities. An example would be where I have one row saying University of...
  3. B

    Fuzzy look up or alike

    I've got two lists of names on two tabs. One is from payroll and one is from the email system we use. People have left but their email accounts have not been deleted. I want to run a check and flag all the names that have email addresses but are not on the payroll so they can be removed...
  4. R

    problem with fuzzy lookup

    Dear Friends, Earlier I installed Fuzzy LookUp in my laptop where Windows 7 was installed. There fuzzy lookup addin was running fine. Recently I installed in another laptop where windows 10 64 bit is installed. But unfortunately fuzzy lookup is not running. After click on Go no result is...
  5. C

    Using "Fuzzy Lookup" to compare 2 columns and return cell contents of adjacent cell to matched record... on Office on OS X

    I know there are great plug-ins for Fuzzy Lookups on Windows machines but I work in a Mac office. I have 3 cols of data: Col A = My accounts Col B = Each account's point of contact Col C = Attendee list I want to know if an account I own in col A is in the attendee list in col C but there...
  6. C

    Using "Fuzzy Lookup" to compare 2 columns... on Office for MAC

    There are great plug-ins for Fuzzy Lookups on Windows machines but I work in a Mac office. I am trying to: I have 2 lists: a Lead List of companies and an event Attendee List I want to compare these lists but there will be spelling inconsistencies between the 2 lists (e.g. - Coca Cola -vs- The...
  7. C

    Fuzzy Lookup Help

    Hello, New here, but this is a great resource. I am having a heck of a time getting my fuzzy lookup to work. I have the following 2 tables: I am trying to use the second table to generate a cost for the first table where the Origin/Dest state pair match 100% and the weight is just the...
  8. sleek12

    Approximate match in columns to merge along with amount

    <tbody> Debtor Amount $ X Insurance ltd 5800 X Ins. Ltd -480 X Insurance Brokers Ltd 4700 X Ins. Brokers ltd -950 Y Enterprises 8900 Y Ent Ltd 950 </tbody> Objective: I have fuzzy logic in my excel but it compares 2 columns , but i have inexact data in debtors...
  9. R

    Comparing two columns using Match Function (Approximate)

    I am trying to compare two columns, each of which contain company names. The list is over 6,000 rows so I would like to use a function and drag it down. Normally, you would use the Match function, but the problem is the company names are slightly different. Example: Column A...
  10. H

    VBA Fuzzy Lookup (Find) - Case Sensitive Issue

    Hi, I have a function that performs a "fuzzy" lookup/find against a set of data to find matching values. For example, for each cell in Field 1, the value in that cell is looked up against the entire range of data in Field 2, and where there is a "Fuzzy" Find/match, that value is populated on...
  11. G

    Approximate match

    Hi. I have a list of upc codes, which should be 12 digits. Unfortunately, some digits have been dropped while doing data entry. I would like to compare these 11 digit upc's to a 'good' list, which contains the upcs they way they're supposed to be - basically doing a vlookup where one character...
  12. S

    Matching column a string with a single value

    <tbody> Model Manufactur and Model H834 Cuisinart H297 H296 Hitatchi L945 L8435 Hitchachi H834 N923k1 Cuisinart H296 </tbody> I have 2 columns on seperate sheets one will contain a single text value, the other a string. I want to return true in the Manufacturer and Model sheet if it is...
  13. R

    How to match fuzzy duplicates in one column

    I have some data in a single column, this data contains titles. Some of the titles are exact matches but others have the same words but just in a different order. Is there a way to find the fuzzy duplicates within a single column?
  14. D

    Help with Fuzzy/Similar Duplicates

    Hello, I am trying to sanitize a spreadsheet of data and get it to be more uniform based on Brand (column A), and PolishName (column B). Using AbleBits Fuzzy Duplicate finder ( https://www.ablebits.com/excel-find-similar/find-fuzzy-excel-duplicates.php ), I was able to find most of the...
  15. T

    Compare two columns for Exact match and Similar matches

    Hi all, I have two spreadsheets (SheetA and SheetB). SheetA has 4 columns, with ColumnA having names. SheetB has only 1 column, ColumnA, containing a different set of names. I need to match SheetA.ColumnA with SheetB.ColumnA, and all matches need the data from SheetA copied to a new...
  16. E

    Matching names using "alias list"

    Here's a great problem that even I can't solve, but I see possible glimmerings of a solution. I have a giant database (250,000 records) and a smaller to-find list (35,000 records), though the sizes are a problem. These are both lists of peoples names and addresses from all around the...
  17. R

    Fuzzy Duplicates, must return values "True" or "False"

    Hi, I've read as much of this forum as I could, and I have also seen FuzzyVLookup, but it doesn't suit my needs (or I don't know how to use it properly, could be the case too.) I have a database of 90 000 lines, which contain clients, company names, emails, logos, etc. by column. I need to...
  18. T

    Adapting array formula to search for strict matches

    In this example, as I understand, the formula is using a fuzzy search both for the count in D column and for the array in E onwards. Am I right in thinking, that if I wanted a strict match I could replace column D with this?: =COUNTIF(B:B,A) Does anyone know how to adapt the second array...
  19. M

    To fuzzy or not to fuzzy? Thats my question...

    Ok so I started a four page thread not realizing what it was going to turn into...I am glad it did as I am now more educated because of it. However I still did not really get my question answered or the formula I need so I decided to repost and ask simply if what I am doing is possible without...
  20. D

    Need to tweak working algorithm to run faster

    Looking for a faster performance...of Damon Ostrander's code. str1 is limited to 24 characters max since the algorithm takes a bit of time (it's exhaustive in it's comparison against ordered combinations). I need help with augmenting the code to reflect if a match is found that it does not...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top