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 specifies the number of columns, on the row with duplicates, that you want to highlight.

    3. Select Highlight all duplicates or Skip first occurrence, depending on how you want your results to appear.

    4. Click "Map columns in selection" in order to map the columns in your selection.

    5. Specify the "Index One" value. If no user input is made, then 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 specifies the number of columns, on the row with duplicates, that you want to highlight.

    3. Select Highlight all duplicates or Skip first occurrence, depending on how you want your results to appear.

    4. Click "Map columns in selection" in order to map the columns in your selection.

    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 A

    • When adjusting "Index One" or "Threshold", please use the arrow buttons on the extreme right of each input field

    • 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 index, in your selection, that will be analysed.

    • If you are removing duplicates "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 finishes running or 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 in your dataset.

    3. Select the option labelled Compare two different columns.

    4. Click "Map columns in selection" in order to map the current number columns in your selection.

    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 B

  • When adjusting "Index One", "Index Two" or "Threshold", please use the arrow buttons on the extreme right of each input field.

  • If you are removing duplicates "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 the "Threshold" value.

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