HOW TO HIGHLIGHT DUPLICATES

Introduction to Highlighting Duplicates

Flookup can be used to highlight fuzzy duplicates in Google Sheets based on matches from a single column. To highlight duplicate values using Flookup, go to Extensions > Flookup > Highlight duplicates and either click By percentage or By sound.

Highlighting Duplicates By Percentage Similarity

    1. Click the menu item labelled "By percentage".

    2. Select a range with one or more columns. This determines the number of columns you want to highlight.

    3. Click "Count columns in selection" in order to get the current number columns in your selection.

    4. In the resulting window, select Highlight all duplicates or Skip first occurrence, depending on how you want your results to appear.

    5. Specify the "Index One" value. If no user input is made, the the first column of the selected range will be analysed.

    6. Specify the "Threshold" value. If no user input is made, then only exact matches will be highlighted.

    7. Click "Highlight duplicates".

Highlighting Duplicates By Sound Similarity

    1. Click the menu item labelled "By sound".

    2. Select a range with one or more columns. This determines the number of columns you want to highlight.

    3. Click "Count columns in selection" in order to get the current number columns in your selection.

    4. In the resulting window, click the dropdown menu and select Highlight all duplicates or Skip first occurrence, depending on how you want your results to appear.

    5. Specify the "Index One" value. If no user input is made, the first column of the selected range will be analysed.

    6. Click "Highlight duplicates".

Key Points

    • The number of columns you select determines the number of cells that will be highlighted in each row.

    • The "Index One" value is the column in your selection that will be analysed.

    • If you are running "By percentage", then duplicates will be values in "Index One" that have a level of similarity that that is equal to or higher than the "Threshold" value.

    • If this function times out, a message will be displayed indicating how many rows have been processed up to that point.

How To Highlight Duplicates Across Two Different Columns

    1. Click the menu item labelled "By percentage" or "By sound".

    2. Select a range of more two columns or more.

    3. Click "Count columns in selection" in order to get the current number columns in your selection.

    4. In the resulting window, select the option labelled Compare two different columns.

    5. Specify your "Index One" and "Index Two". These are the two columns to compare to each other.

    6. If you are running "By percentage", adjust the "Threshold" value to match your needs.

    7. Click "Highlight duplicates".

Key Points

  • If you are running "By percentage", then duplicates will be values in "Index One" that exist in "Index Two" and have a level of similarity that is equal to or higher than "Threshold value".

  • If this function times out, a message will be displayed indicating how many rows have been processed up to that point.