REMOVE DUPLICATES

Overview

The Remove Duplicates tool helps you clean your data by identifying and removing redundant records based on your selected criteria, from exact text matches to intelligent fuzzy similarity.

How to Use the Remove Duplicates Tool

  1. Select the function to run
    Open Flookup and select Remove Duplicates.
  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