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.
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.
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.
