In Step 3, specify whether your data has a header or not and whether you want to skip empty cells or not.In Step 2, make sure Duplicates is selected.
You can also check the box to create a backup copy of the Google sheets document. In Step 1, make sure the correct range is selected.This will open the ‘Find duplicate or unique rows’ dialog box (it may ṭake a few seconds) Click on ‘Find duplicate or unique rows’.Hover the cursor over the ‘Remove Duplicates’ option.Select the dataset in which you have the duplicates that you want to remove.The above steps would add the Remove Duplicate add-on in your Google Sheets document and now you can start using it.īelow are the steps to use this add-on to delete the duplicate records in Google Sheets: Enter the credentials and click on the blue ‘Allow’ button. In the dialog box that appears, it may ask you to confirm your account by logging in to your Gmail.
Google docs excel find duplicates install#
In the Remove Duplicates add-on screen, click on the blue Install button.In the list of add-ons that are shown, click on the ‘Remove Duplicate’ add-on.In the Add-ons dialog box that opens, search for ‘Remove Duplicate’ in the field in the top-right.Open the Google Sheets document in which you want to remove the duplicates.To use an add-in, you first need to add it to your Google Sheets document.īelow are the steps to add an add-on in your Google Sheets document: The Remove Duplicates add-on by AbleBits is one of the best add-ons to remove duplicate records from your dataset. The duplicate removal add-ons can all be used for the same purpose. Google Sheets, as a rule, supports a massive library of various add-ons to take care of every conceivable issue or problem.
Google docs excel find duplicates how to#
In such a case, you can use the below formula: = ArrayFormula ( UNIQUE ( TRIM ( A2:B17 ) ) )Īlso read: How to Keep Leading Zeros in Google Sheets Remove Duplicate using an Add-on In case your data has leading, trailing or extra spaces, the unique function will consider the records as different. In case you only want to keep one instance of a country name and delete all the other, UNIQUE will only do it if the rest of the column values for that record are also the same. One of the limitations of using the UNIQUE function is that it would consider only those records as duplicate where the entire row content repeat. And in case you overwrite any cell, the entire result would go away and you will see a #REF! error. Nothing will happen in case you try to delete any one cell from the result. The result is an array of unique records and you can not delete or edit part of this array result. The above formula will give you the result starting from the cell in which you entered the formula. The below formula would remove all the duplicate records and you will get all the unique ones: = UNIQUE ( A2:B17 ) Suppose you have the dataset as shown below and you want to remove all the duplicate records from this dataset: Google Sheets also has a function that you can use to remove the duplicate values and keep the unique values only. It simply deletes the duplicate records from the cells (without disturbing cells around the dataset) Also read: How to Highlight Duplicates in Google Sheets Remove Duplicates using the UNIQUE function This means that using it doesn’t remove the rows or delete any cells.
When you use the ‘Remove Duplicates’ option to get rid of the duplicate records, it wouldn’t impact the data around it. The above steps would instantly remove all the duplicate records from the dataset and you would get the result as shown below.