REMOVING DUPLICATES

Flookup helps maintain data integrity in Google Sheets by removing duplicate entries. This guide covers how to deduplicate data based on exact matches, percentage similarity or sound.

Removing Duplicates by Percentage or Sound Similarity

  1. Select the function to run
    Click the menu item labelled By percentage or By sound, depending on your needs.
  2. Select the entries to deduplicate
    Highlight the single column of data you wish to deduplicate and click Grab selected range.
  3. Specify the result location
    Click an empty cell within the spreadsheet to mark the position where the results should be displayed.
  4. Enter the level of similarity
    (Only for "By percentage") Enter the Threshold value. If no user input is made, the default threshold of 0.8 will be used. Higher values require closer matches; lower values are more permissive.
  5. Remove the duplicates
    Click the Remove duplicates button to finish.

Removing Duplicate Rows (Whole Table)

  1. Select the function to run
    Click By percentage or By sound.
  2. Select the table to deduplicate
    Highlight the entire range or table of data you wish to deduplicate and click Grab selected range.
  3. Specify the matching column
    Enter the index of the column to be used for matching (e.g., 2 for column B).
  4. Specify the result location
    Click an empty cell within the spreadsheet to mark the position where the results should be displayed.
  5. Set the level of similarity
    (Only for "By percentage") Adjust the Threshold value as needed.
  6. Remove the duplicates
    Click the Remove duplicates button to finish.

Removing Duplicates Across Two Separate Columns

  1. Select the function to run
    Click By percentage or By sound.
  2. Select the first column
    Highlight the first column of data and click Grab selected range to read it into Left_column.
  3. Select the second column
    Highlight the second column of data and click Grab selected range to read it into Right_column.
  4. Specify the result location
    Click an empty cell within the spreadsheet to mark the position where the results should be displayed.
  5. Set the level of similarity
    (Only for "By percentage") Adjust the Threshold value as needed.
  6. Remove the duplicates
    Click the Remove duplicates button to finish.

Removing Duplicates Based on Cell Value

  1. Click By percentage or By sound
    Select Remove duplicates by cell value from the second drop down.
  2. Select the range to deduplicate
    Highlight the column or range of data you wish to deduplicate and click Grab selected range.
  3. Select the value to remove
    Highlight the single cell containing the value you wish to remove from the range and click Grab selected range.
  4. Specify the result location
    Click an empty cell within the spreadsheet to mark the position where the results should be displayed.
  5. Set the level of similarity
    (Only for "By percentage") Adjust the Threshold value as needed.
  6. Remove the duplicates
    Click the Remove duplicates button to finish.

Rolling Up Data in a Selection by Row

  1. Click By percentage
    Select Roll up data in selection by row from the second drop down.
  2. Select the range to deduplicate
    Highlight the range you wish to deduplicate and click Grab selected range.
  3. Specify the result location
    Click an empty cell within the spreadsheet to mark the position where the results should be displayed.
  4. Set the threshold
    (Only for "By percentage") Adjust the Threshold value as needed.
  5. Remove the duplicates
    Click the Remove duplicates button to finish.

Using Percentage or Sound Similarity to Create a Unique List

  1. Select the function to run
    Click By percentage or By sound.
  2. Select the range to deduplicate
    Highlight the column or range of data you wish to process and click Grab selected range.
  3. Specify the result location
    Click an empty cell within the spreadsheet to mark the position where the results should be displayed.
  4. Set the level of similarity
    (Only for "By percentage") Adjust the Threshold value as needed. Higher values are stricter; lower values are more permissive.
  5. Remove the duplicates
    Click the Remove duplicates button to finish.

Visual Learning Resources

Labels might differ slightly but the steps remain the same.

You Might Also Like