Video: How to delete duplicates in Google Sheets

See how you can quickly check your data for unique entries and compare two columns or even tables for duplicate rows. Find, color, or delete the found values in Google Sheets: Remove Duplicates add-on will offer six different ways to deal with the results.

Once you get the add-on from the store, you will see Remove Duplicates item in the list of your add-ons with two possibilities:

The following two videos show how you can work with both wizards.

How to find and remove duplicate lines in Google Sheets

In this video, you will see how to quickly find duplicate rows in one table.

Remove duplicates in Google Sheets: video transcript

Remove Duplicates is a simple tool for Finding unique and duplicate records in Google Sheets.
Now let's see how we can quickly discover the same records in one table: here I have a list of requested books, and I want to eliminate any duplicates.

To do this, use the first tool that comes with the add-on: Find Duplicates or uniques. It will select the range with your data right away, and you can always change it using this little icon.

We always recommend using the possibility to back up your sheet - this will let you get a copy of it, so you can always go back to your original data.

Click Next to choose the type of data you want to find. You can look for unique values, duplicates, and include the original values. In our example we need to keep our first occurrences, so let's select duplicates and click Next

This step is very important as here you define the columns you want to consider for the search.
Say, if you are looking for duplicate IDs, this is the only column you will select. If you want to find duplicate rows, you need to keep all columns selected.
The add-on can also look at the combination of values in the selected columns, for example, we can look for those duplicate book titles that also have the same ID, and this way we will ignore all unique IDs even if the title is the same.

Finally, you can choose to delete the selected rows with duplicates, highlight them with any color, mark them with status, copy or move them to another location, or simply clear duplicate values in the key columns without deleting the rows.

Click Finish to see the duplicates and the number of items the add-on has found.

If you need to compare two columns or tables, please watch the next video.

If you have any questions about removing duplicates in Google Sheets, please contact us right from within the add-on, we'll do our best to help.

How to compare two columns or sheets for duplicates

This video will show how you can quickly compare data from two columns, or match entire rows from two Google Sheets.

Compare lists in Google Sheets for duplicates: video transcript

When you need to find duplicates between two columns or sheets, this add-on will become your favorite assistant. There are five simple steps you need to follow.

Open your main table and go to Add-ons -> Remove Duplicates - Compare columns or sheets.

It will quickly find the range with your table, but you can select a different sheet in the drop-down list and update the range in this field. If you need to compare two columns, select your first column here.

Click Next and select the second table to compare against: here I want to find those of the requested books that were already ordered, and I can use this field to enter the range with data I want to look at.

Step 3 lets you find those values that are present only in table 1 or those that are repeated in table 2.

On step 4 you can choose the columns to compare. This step makes this add-on a life-saver when you want to find duplicates by more than one column: say each author may have different books, so I can select all these columns to find the same books by the same authors.

The last step lets you decide what to do with the found rows: you can mark them with color or a status column, copy or move them, clear values in the key columns, or delete the rows.

Click Finish and you will get an overview of the result and in our example, we will see a list of books that are still waiting to be ordered.

If you have any questions about comparing columns or tables in Google Sheets, please contact us right from the add-on: you can use these two icons to send an email or post in our community, we'll do our best to help you.

See also

3 Responses to "Video: How to delete duplicates in Google Sheets"

  1. Geetha says:

    Provides great information about the concept.It helps an individual to gain knowledge on new techniques.Keep on giving this type of information.

  2. Sanjeet Shokeen says:

    I have a table in which first column i add date 1 July to 26 July 2016. In second column, I give rating to me (e.g. 0 to 10). I want to sum my rating only past 5 days but when last 5 day rating is less than 2, then add one more day. e.g.
    Date Rating
    15 July 5
    16 July 3
    17 July 0
    18 July 8
    19 July 2
    20 July 6
    21 July 7
    23 July 1
    24 July 5
    25 July 6
    26 July 3

    when I sum last 5 day (21 July to 26 July) is 22, but 23 July my rating is less than 2 than I add one more day in rating (20 July to 26 July) than my rating is 27, I remove 23 July in my life.

    Can you you help me in this.

    Than You.

    • Hello Sanjeet,
      Could you please clarify what should happen if there are more values that are less than 2 within the last 5 days? Also, what if the day you add also has a rating less than 2? If neither case is a concern, you can use the following formula:
      =IF(COUNTIF(B2:B6,"<2")>1, SUM(B2:B6),SUMIF(B1:B6,">=2"))

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!