I Love Egypt!

Tuesday, May 7, 2019

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



from How-To Geek http://bit.ly/2J7tRFC
via IFTTT

No comments :

Post a Comment