How to Remove Duplicates in Google Sheets

18 views
Skip to first unread message

Flookup for Google Sheets

unread,
Aug 28, 2021, 5:16:37 AM8/28/21
to Flookup for Google Sheets
Flookup can be used to remove duplicates in Google Sheets based on matches from a single column.

To remove duplicates using Flookup, go to Add-ons > Flookup > Remove duplicates and either click By percentage or By sound.

By Percentage Similarity

With this function, Flookup finds and deletes selected rows that contain duplicate values with a specific minimum percentage similarity between them. The steps to remove duplicates by this method are:

  1. Select values in a range.
  2. Find and click the menu item labelled "By percentage".
  3. A prompt is displayed requesting the user to enter the "Target column" and the "Threshold value". If no user input is made, values which have a hundred percent similarity match between them will be found and the first column of the selected range will be analysed.

All selected rows containing duplicate values, with the specified percentage similarity between them, will be deleted.

By Sound Similarity

With this function, Flookup deletes selected rows that contain duplicate values based on the sound similarity between them. The steps to remove duplicates by this method are:

  1. Select a range.
  2. Find and click the menu item labelled "By sound".
  3. A prompt is displayed requesting the user to enter the "Target column". If no user input is made, the first column of the selected range will be analysed.

All selected rows containing values with similar sounds will be deleted.

Note
  • The Target column is the column that will be analysed.

  • The Threshold value is the level of similarity below which items will not be considered duplicates.

How To Remove Duplicates Across Two Different Columns

You can also compare two different columns for percentage or sound similarity.

These steps are largely similar to the other modes above except that, for this task, you must tick the checkbox labelled "Compare two different columns" in the function window.

Here are the steps in detail:

  1. Select a range of more than one column.

  2. Find and click the menu item labelled "By percentage" or "By sound".

  3. In the resulting window, check the box labelled "Compare two different columns".

  4. Specify your Target column and the Secondary column. These are the two columns to compare.

  5. Adjust the "Threshold value" to match your purpose (if this option is available).

  6. Click "Remove duplicates".

You can also extract unique values from your dataset by using our ULIST function, much like the UNIQUE function found in Google Sheets but with the advantage of fuzzy matching. Find out more by clicking here.

Reply all
Reply to author
Forward
0 new messages