Knowledge Books

Home → Google → Google Sheets → Using the Unique Function

13.9. Using the Unique Function

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-it interactive" to select your preferred viewing method. Then, click start.


8 STEPS

1. The Unique Function returns unique rows from the cells you provide it, discarding duplicates. Open your desired Google Sheet, select the area in which you would like place the "Unique" function (Column R for us), then click Insert.

Step 1 image

2. With your mouse, hover Function

Step 2 image

3. With your mouse, hover All►

Step 3 image

4. Scroll down and click UNIQUE

Step 4 image

5. The function is now in my cell, but I need to provide a range of data to pull "unique selections" from. The easiest way is to highlight specific cells. Click and highlight your desired cells to sort.

Step 5 image

6. highlight the entire range and it will automatically insert into your function

Step 6 image

7. Hit enter or click out of the cell with the function and we now see that "15, 16, and 17 are the three unique numbers within rows Q2 through Q11. 

Step 7 image

8. That's it. You're done.

Step 8 image

Here's an interactive tutorial

https://www.iorad.com/player/1737924/Google-Sheets---Using-the-Unique-Function


Downloads

Knowledge Tags
Google Sheets  /  functions  /  unique  /  sorting  / 

← Using the Average Function Using the Count Function →