Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using fuzzy logic in excel
Hello everyone,
does anyone know of an application or vb code that can be used to search in two worksheets (like VLOOKUP) on similar matches using fuzzy logic? For example, if on one sheet I have I.B.M and the other IBM or James Smith on one and Jim Smith on the other, is there anyway of giving confidence codes to the match? Thanks very much for your help, James |
#2
|
|||
|
|||
AFAIK this does require VBA code. I wrote an Access utility in VBA
that does exactly this cho it works by scrubbing punctuation out of each list, then comparing each "word" ("Ed" and "Begley" and "Jr" are each words in this context) in each entry in list A to each word in each entry in list B. The output is an integer number corresponding to the number of word matches found. |
#3
|
|||
|
|||
Hello James-
Based on the nature of your data, it could be possible that VLOOKUP uses logic "fuzzy" enough as it is. If the lookup values include many similar entries, though, that may not be the case. Forgive me if you are already aware of this, but although the fx does look for an exact match, but it uses the preceding row once it finds an item that is "higher" than what it is looking for. The key is that the lookup table must be sorted in ascending order based on the first column. FWIW |:) "James" wrote: Hello everyone, does anyone know of an application or vb code that can be used to search in two worksheets (like VLOOKUP) on similar matches using fuzzy logic? For example, if on one sheet I have I.B.M and the other IBM or James Smith on one and Jim Smith on the other, is there anyway of giving confidence codes to the match? Thanks very much for your help, James |
#4
|
|||
|
|||
Thanks for your help.
James -----Original Message----- Hello James- Based on the nature of your data, it could be possible that VLOOKUP uses logic "fuzzy" enough as it is. If the lookup values include many similar entries, though, that may not be the case. Forgive me if you are already aware of this, but although the fx does look for an exact match, but it uses the preceding row once it finds an item that is "higher" than what it is looking for. The key is that the lookup table must be sorted in ascending order based on the first column. FWIW |:) "James" wrote: Hello everyone, does anyone know of an application or vb code that can be used to search in two worksheets (like VLOOKUP) on similar matches using fuzzy logic? For example, if on one sheet I have I.B.M and the other IBM or James Smith on one and Jim Smith on the other, is there anyway of giving confidence codes to the match? Thanks very much for your help, James . |
#5
|
|||
|
|||
Hi Dave,
I don't seem to be a -----Original Message----- AFAIK this does require VBA code. I wrote an Access utility in VBA that does exactly this cho it works by scrubbing punctuation out of each list, then comparing each "word" ("Ed" and "Begley" and "Jr" are each words in this context) in each entry in list A to each word in each entry in list B. The output is an integer number corresponding to the number of word matches found. . |
#6
|
|||
|
|||
Hi Dave,
I don't seem to be able to read your whole reply. Are you able to share the access utility that you created? Thanks, James -----Original Message----- AFAIK this does require VBA code. I wrote an Access utility in VBA that does exactly this cho it works by scrubbing punctuation out of each list, then comparing each "word" ("Ed" and "Begley" and "Jr" are each words in this context) in each entry in list A to each word in each entry in list B. The output is an integer number corresponding to the number of word matches found. . |
#8
|
|||
|
|||
Google fudged my email address: it is
cyclezen at yahoo dot com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Excel Logic Function | Excel Discussion (Misc queries) |