How to Remove Duplicates in Google Spreadsheets

This video was brought to you by Profound Cloud

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

Using the 'Unique' function will allow you to remove duplicate items from a single row, or several rows.

This is a great tool for de-duplicating a list of contacts, email addresses or anything else you might be using.

The function is described in Spreadsheets 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 Spreadsheet:

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)

To watch the updated video and read the full article on the BetterCloud Monitor, visit:
bettercloud.com/monitor/the-academy/how-to-remo…