Flookup is a Google Sheets add-on that relies on fuzzy matching to do any of the following data cleaning tasks: 1. Remove duplicates. 2. Highlight duplicates. 3. Match or merge data. 4. Calculate the percentage similarity between strings.
@kurosh_hashemi Apologies for that. The error appeared because of Google's security review process, but it is now complete and Flookup back online.
Please try to run the installation again. Thank you.
This is super cool - I once had to hack together a Levenshtein distance function in VBA to use in Excel so it's rad to have this in Google Sheets - great work Andrew!
@alxcnwy Thanks for the encouraging words Alex... very kind of you!
I have also used Levenshtein distance in the past (as I said in my story). I was fascinated by the way it matched words that didn't look the same; something I had not seen or known before that time. It played a huge role in bringing Flookup to where it is today.
It can be used to perform vertical lookups on any column and horizontal lookups on any row, based on percentage or sound similarity.
It can also be used to highlight or delete duplicate values by sound or percentage similarity.
Pros:
Flookup makes working with unsorted, uncleaned or even clean data much easier
Replies
RoadGoat
Flookup Data Wrangler
Flookup Data Wrangler
Flookup Data Wrangler
It can be used to perform vertical lookups on any column and horizontal lookups on any row, based on percentage or sound similarity. It can also be used to highlight or delete duplicate values by sound or percentage similarity.
Pros:Flookup makes working with unsorted, uncleaned or even clean data much easier
Cons:It doesn't work offline