This function returns a list of all the unique values in a cell range.

Syntax

UNIQUE(array,[by_col],[occurs_once])

Arguments

UNIQUE function has the following arguments:

Argument	Description
array	[required] Specifies the range or array from which you want to return unique values.
by_col	[optional] Specifies the logical value that indicates how to compare. If this argument is TRUE, it refers to "by column" and if FALSE, it refers to the "by row".
occurs_once	[optional] Specifies a logical value. If this argument is TRUE, it will return unique values that occur only once. In case the value is FALSE, all the unique values will be included in the result.

Data Types

Accepts a range or array. Returns a list of unique values.

Examples

For instance - The cell C4 in the following image contains the formula "=UNIQUE(A4:A15)" and returns only the unique customer names from the values in cell range A4 to A15. Based on the number of unique values, the dynamic array formula spills to the cell range C5 to C8 automatically.

Version Available

This function is available in Spread for Windows Forms 12.1 or later.