Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud

UNIQUE Function

The UNIQUE function is one of the lookup and reference functions. It is used to return a list of unique values from the specified range.

Syntax

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

The UNIQUE function has the following arguments:

Argument Description
array The range from which to extract unique values.
by_col The optional TRUE or FALSE value indicating the method of comparison: TRUE for columns and FALSE for rows.
exactly_once The optional TRUE or FALSE value indicating the returning method: TRUE for values occurring once and FALSE for all unique values.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the UNIQUE function.

Examples

The figure below displays the result returned by the UNIQUE function.

UNIQUE Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action