![]() I have set it to both False and True which have had no impact. The only other Fuzzy Lookup settings I have changed were in Configure -> Global - UseApproximateIndexing. I have uninstalled & reinstalled the add-in, and have used the default settings. Neither have spaces before or after them, and the first 12 characters are identical. Should have some degree of similarity to: 761689700000EN4239īut the Fuzzy Lookup add in returns 0.000 for it. Some that I expected to have some degree of similarity, instead have 0.000 returned by the Add-In. W2-NK22/16 in one worksheet shows to have a 0.97 similarity to W2NK2216.īut not in all cases. The fuzzy lookup appears to run without a problem, and the results - in most cases - appear to be correct. The "Fuzzy Lookup" is comparing one column from each & returning a similarity between the two. First worksheet has around 48,000 rows (x 3 columns), second worksheet has around 23,000 rows (x 5 columns). Using Excel 2010, and the Microsoft "Fuzzy Lookup" add in to compare a column out of 2 worksheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |