how to remove duplicates in google sheets

how to remove duplicates in google sheets

Removing duplicates in Google Sheets is the act of removing data that appears more than once or removing duplicate entries in your sheet.

This should be done before carrying out any data analysis to avoid errors and prevent unnecessary corrections.

Today in this post, I will show you how to remove duplicates in Google Sheets using any of the available methods.

Google sheet or spreadsheet is now serving the same purpose as MS Excel, which is being powered by the Google Drive Suite.

However, the Google sheet is becoming more common and advanced with the help of easy to use scripts and add-ons.

As well, providing the full list of various functions to help you in quick computing and calculations.

Making use of the Google sheets to sort and organize a vast amount of data can be tiring and stressful, especially getting rid of duplicate data entries.

Hence, if you know how to find duplicate data entries in the Google sheet, then removing them will be a great move.

But, if you don’t know how to achieve this, then, this guide will be of help to you anytime any day.

With the help of Google drive by integrating add-ons and functions, getting rid of duplicates in Google sheets can be done in a few minutes.

Let’s quickly see the available methods on how to remove duplicates in Google Sheets.


How to Remove Duplicates in Google Sheets

There are so many methods on how to remove duplicates in Google sheets, which includes;

  • How to remove duplicates with an Add-On.

  • How to remove duplicates with Apps Script.

  • How to remove duplicates with Pivot Tables.

  • How to remove duplicates in Google sheets with the UNIQUE Function.

  • How to remove duplicates in Google sheets with Conditional Formatting.

  • How to remove duplicates in Google sheets with the Remove Duplicates tool.

Nevertheless, this guide will teach you how to remove duplicate cells in Google sheets using the UNIQUE Function.

This is the best and easiest method so far, and it works perfectly well for me.

So, let’s quickly see the steps to follow below here.

How to use the UNIQUE Function to Remove Duplicate Cells

Step 1: First, visit the site here on in your internet browser.

If you are not signed in yet, then sign in to your Google account and a list of Google spreadsheets files will be displayed.


Step 2: Select the particular file you want to edit that has rows/columns containing duplicates data entries in the cells.

how to remove duplicates from google sheets

Step 3: Click on an empty cell away from the row/columns where your data is located at.

Then, you will now enter the Function in that cell.


Step 4: On the empty cell, type in “=UNIQUE(range),” and replace  “range” with the cell range where the duplicates occur.

Example, as seen in the image below, to find the duplicates in column A (Boy Names) from row 2 to 8, we type =UNIQUE(A2:A8).

how to find duplicate entries in google sheets

Step 5: After typing in the Function, quickly press the Enter key on your computer keyboard.

It will then create a new cell range containing the data entries but without the duplicates.

remove duplicates in google sheets

You can now copy and replace the original cell range with the new data cells having no duplicates.

If you no longer want the data in the original cells, highlight, and copy, then paste in the first column of the original cells.

You can achieve that using CTRL+C for copy and CTRL+V to paste.

Read Also: How to Use Salesforce for Sales

That is all on how to remove duplicates in Google sheets and how to merge duplicates in Google sheets.

With the help of this UNIQUE Functionyou can quickly sort and remove duplicates in Google sheets easily.

Therefore, take advantage of this today, and you will be glad you did.

Remember to share this article with your friends and on social media platforms.

Thank you!

Related Articles: