Skip to content

Remove Duplicates in Google Sheets

Here are two ways you can remove duplicate values in Google Sheets.

Method 1 – Use the Menus

Let’s say you have a list of colors in Google Sheets.

How do you remove the duplicate values so that you are left only with unique colors? Follow the steps below.

Start by selecting all the colors with your mouse.

In the Google Sheets menus, go to Data > Data cleanup > Remove duplicates.

In the window that appears, click on Remove duplicates.

You now have a list of all unique colors with no duplicate values.

Method 2 – Use the UNIQUE Function

You can use the UNIQUE function to get a list of unique values from a referenced range. Here is how to use it.

Start by typing in the UNIQUE function, and enter your range of values for the first argument.

Press the Enter key, and the UNIQUE function generates a list of unique values from your list.

And there you have it – two simple ways to remove duplicates in Google Sheets!

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top