fuzzy

Hello, I am trying to find out how to identify near duplicates in a large excel sheet based on a monetary value. For example, If i have 2 rows I want to be able to highlight these as potential duplicates if the number is within certain criteria. Is there a formula that I can create to say: If...

Hi all, I have inherited some fuzzy match code (below) which compares two text strings, it works fine and gives me the character similarity I need, but it also gives me 5 columns of other data (which I don't want or need). Example below. Would anyone know which bit of the below to edit out so...

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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