UNIQUE practice

UNIQUE returns the distinct values in a range, in Google Sheets. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

UNIQUE(range)

What people get wrong

COUNTA(UNIQUE(range)) counts distinct customers.

Google Sheets exercise that use UNIQUE

Distinct customersLevel 4Pro

Often used together with: COUNTA

Practice UNIQUE now

The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.

Start practicing free