How to Remove Duplicates in Google Sheets

Google Sheets lets you remove duplicates from your document with three methods ranging from a simple integrated function to a custom script. While it’s not as apparent as in Excel, Sheets offers a more diverse way to remove duplicates in your spreadsheet.

RELATED: How to Remove Duplicate Rows in Excel

Remove Duplicates Using the Unique Function

The first method we’re going to look at uses the built-in Google Sheets function that finds all unique entries, letting you get rid of everything else in the data set.

Fire up your browser and open up a spreadsheet to get started.

A sample table with duplicates

Next, click the empty cell where you want the data to output, type =UNIQUE, and then click on the suggested function that appears in the dialog window.

Select an empty cell and start typing =Unique, then click on the suggestion that appears

From here, you can either manually enter the range of cells or highlight them for the function to parse. When you’re done, hit Enter.

Read the remaining 51 paragraphs

Source: https://www.howtogeek.com/413134/how-to-remove-duplicates-in-google-sheets/
Proactive Computing found this story and shared it with you.
The Article Was Written/Published By: Brady Gavin

Author: Droolin' Dog News Team