Skip to content

UNIQUE function in Excel

UNIQUE returns the unique values in a range (spills).

Syntax

=UNIQUE(array)
ArgumentRequired?What it is
arrayRequiredThe range or array to work on.

Practise UNIQUE in a live spreadsheet

Type the formula yourself and get it graded instantly, no Excel needed.