Tim Hanson
Member
I need code to fuzzy Match on two lists of names "LookIn" list in Col A "LookFor" list in ColB on sheet1, both list are in the shape "FirstName LastName"
Some times Col A is longer then Col B sometimes the opposite is true
Col A is the master list an Col B where a match exists is either a exact match or a misspelling or a different way writing the name e.g
I have tried the FuzzyMatching addin but it has inconsistent results, also I have searched for fuzzy matching code and there were some out there they did not do what I needed and the writing of the code is simply beyond me
I need where there is a fuzzymatch to have 5 best matches placed in the adjacent cells in the same row next to the cell that was matched, all exact matches can be ignored
I have uploaded a file to demonstrate what I am hoping for
Thank you
Some times Col A is longer then Col B sometimes the opposite is true
Col A is the master list an Col B where a match exists is either a exact match or a misspelling or a different way writing the name e.g
Code:
ColA ColB
James l.Hanson, Ph.d, Blah Jim HansonI have tried the FuzzyMatching addin but it has inconsistent results, also I have searched for fuzzy matching code and there were some out there they did not do what I needed and the writing of the code is simply beyond me
I need where there is a fuzzymatch to have 5 best matches placed in the adjacent cells in the same row next to the cell that was matched, all exact matches can be ignored
I have uploaded a file to demonstrate what I am hoping for
Thank you