Add-ons
Check out the store for many more
Add-on

Flookup


(21)
offered by getflookup.com
1,669 users

Overview

Flookup compares text and searches data sets based on percentage or sound similarity.
Core Functions of Flookup:
1. FLOOKUP: It searches for strings in vertically structured data, based on percentage similarity. Matches for each lookup value are returned in order of descending percentage similarity.
2. HFLOOKUP: It searches for strings in horizontally structured data, based on percentage similarity. Matches for each lookup value are returned in order of descending percentage similarity.
3. SOUNDMATCH: It searches for strings based on sound (as pronounced in English) in vertically structured data. Matches for each lookup value are returned in alphabetical order (A-Z).
4. FUZZYMATCH: It calculates the percentage similarity between two strings. It can also calculate the percentage similarity between concatenated strings.
5. LATINIZE: It removes diacritical marks from any string. This is especially useful if applied before using any of the functions mentioned above.
6. ULIST: It returns unique values from a specified range based on percentage similarity.

Additional Features:
1. Highlight selected rows containing duplicate values based on percentage or sound similarity.
2. Delete selected rows containing duplicate values based on percentage or sound similarity.

Flookup eliminates the need to:
1. Sort data sets.
2. Change the letter case of the text.
3. Remove extra spaces.
4. Remove punctuation marks.

WEBSITE: https://www.getflookup.com
DONATE: https://www.getflookup.com/donate
SUPPORT: https://www.getflookup.com/feedback

Details

Version: 104
Updated: August 15, 2019
Language: English