SORT & UNIQUE practice exercises

UNIQUE removes duplicates from a list, and SORT orders a range by one or more columns. Combined, they turn a messy column into a clean, sorted list that updates by itself.

Syntax

UNIQUE(range)   ·   SORT(range, sort_column, is_ascending)
UNIQUE(range)
Returns each distinct value (or row) once.
SORT(range, col, asc)
Sorts range by its col-th column; TRUE for A→Z / small→large, FALSE for the reverse.

The practice data

An orders table: who sold what, where, and for how much. Every exercise below uses this sheet, and your answer goes in H2.

ABCDEF
1RepRegionProductUnitsPriceSales
2AnaEastWidget12560
3BenWestGadget520100
4CaraEastGadget820160
5DevNorthWidget205100
6AnaWestGizmo350150
7BenEastWidget7535
8CaraNorthGizmo250100
9DevEastGadget620120

Worked example

=UNIQUE(B2:B9)

Lists each Region once, in order of first appearance. Result:

East
West
North

Your turn: 3 exercises

Type a formula and press Enter. It is checked by a real formula engine, so any correct approach counts.

1 List each Product once.

H2

2 List each Rep once, sorted A to Z.

H2

3 Return the whole table (A2:F9) sorted by Sales, highest first.

H2

Master SORT & UNIQUE in the full course

Lesson 15 of 18 goes deeper, with more exercises in a real spreadsheet grid. Start with the first 4 lessons free, then unlock everything with Pro.

Start free See pricing

Common SORT & UNIQUE mistakes

FAQ

How do I count unique values?

Use COUNTUNIQUE(A2:A9) or COUNTA(UNIQUE(A2:A9)).

Can I sort by two columns?

Yes: SORT(A2:F9,2,TRUE,6,FALSE) sorts by Region, then by Sales descending.

Keep practicing