UNIQUE function in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the UNIQUE function do in Google Sheets?

The UNIQUE function returns a list of unique values from a range or array, removing any duplicates.

beginner

How do you write a UNIQUE function to get unique values from cells A1 to A10?

You write =UNIQUE(A1:A10). This will list all unique values found in that range.

intermediate

Can UNIQUE function handle multiple columns? If yes, how?

Yes, UNIQUE can handle multiple columns. For example, =UNIQUE(A1:B10) returns unique rows considering both columns together.

beginner

What happens if the UNIQUE function finds no duplicates in the range?

It returns the original list as is, because all values are already unique.

intermediate

How does UNIQUE function treat blank cells in the range?

UNIQUE treats blank cells as a value and will return a single blank if blanks exist in the range.

What formula would you use to get unique values from column C?

A =SORT(C:C)

B =UNIQUE(A1:B10)

C =FILTER(C:C, C:C>0)

D =UNIQUE(C:C)

The formula =UNIQUE(C:C) returns unique values from column C.

If you want unique rows from columns A and B together, which formula is correct?

A =UNIQUE(B1:B10)

B =UNIQUE(A1:A10)

C =UNIQUE(A1:B10)

D =UNIQUE(A1:A10, B1:B10)

UNIQUE(A1:B10) returns unique rows considering both columns A and B.

What will UNIQUE return if the range has no duplicates?

A The original list unchanged

B An error

C An empty list

D Only the first value

UNIQUE returns the original list if all values are unique.

How does UNIQUE treat blank cells in the input range?

A Returns a single blank if blanks exist

B Returns multiple blanks for each blank cell

C Ignores all blank cells

D Throws an error

UNIQUE returns one blank if there are blank cells in the range.

Which of these is NOT a use of UNIQUE function?

A Remove duplicate values

B Sort values alphabetically

C List unique rows from multiple columns

D Extract unique entries from a list

UNIQUE does not sort values; it only extracts unique values.

Explain how the UNIQUE function works and give an example of its use.

Think about how you find unique names in a list.

Describe how UNIQUE handles multiple columns and blank cells.

Consider how rows are compared and how empty cells appear.