currently, i'm working on project involves lot of data clean-up , combining data.
the data i'm working includes account name , address information (address 1, address 2, city, state, zip code). i've been using excel fuzzy lookup add-in locate records greater or equal 90% similarity threshold. i'm ready move forward automating process, but, unfortunately, there isn't way access add-in via vba.
i've found number of different functions (weighted damerlau-levenshtein, jaro-winkler similarity, etc), none of them seem accurate microsoft add-in. since add-in uses weighted jaccard similarity, i'm wondering if has found or developed function accomplish this?
Comments
Post a Comment