All functions / Dynamic arrays

UNIQUE

Removes duplicates from a list. The result spills.

Syntax

=UNIQUE(array, [by_col], [exactly_once])

Arguments

• array: The list.
• by_col (optional): TRUE to compare columns instead of rows.
• exactly_once (optional): TRUE to return only values that appear exactly once.

Example

=UNIQUE(B2:B50) → Each region listed once

Practise it

• Finding duplicates
• Spilling arrays: UNIQUE and SORT