How to Remove Duplicates in Google Sheets

 

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.

Get the best tips and tricks in your inbox daily