If you work in IT, learn how BetterCloud’s Unified SaaS Management platform can help you manage G Suite and other applications. Also, learn how you can 10x your G Suite productivity

A lot of people are familiar with how to remove duplicates in Excel, but they often struggle with finding the same functionality in Google Sheets.

The “Unique” function will allow you to remove duplicate items from a single row, or several rows. This is a great tool for deduplicating a list of contacts, email addresses, and many other types of lists.

The function is described in sheets as: “Returns only the unique rows in the source array, discarding duplicates. The rows are returned according to the order in which they first appear in the source array.”

To remove duplicates from your Sheet:

1.) Select the cell where you would like the de-duplicated info to begin

2.) Enter the function =UNIQUE(

3.) Select the cells you would like to pull data from

4.) Close the parentheses. Your function should look something like this:

=UNIQUE(B:B)

Click here to watch this video on YouTube.

Shares

UP NEXT: Be the Boss of Your Slides by Using the Slide Master in PowerPoint

Leave a Reply

8 Comments on "How to Remove Duplicates in Google Sheets"

Notify of
avatar
Sort by:   newest | oldest | most voted
Peter
Guest
Peter

If you need the actual values from =Unique you can always cut and paste using “Paste Special>Paste Values Only” to get the values in place of the results of the function.

Pogi
Guest
Pogi

Very helpful… Thanks

Maria
Guest
Maria

I am trying to do a similar idea. I need a filter that will count multiple entries in a spread sheet by the same person.

Yijie
Guest
Yijie

Good tip! I demonstrate the UNIQUE function too – unfortunate thing is that it is not case-sensitive. So a response “Swimming” and another “swimming” are recorded as 2 distinct entries.

Nick
Guest
Nick
Nick
Guest
Nick
Joe
Guest
Joe

it’s not free

Crystel
Guest

This was the most simple way to remove duplicates. I spent way too much time reading other more complicated processes. Thank you so much!

wpDiscuz