
UNIQUE function returns unique values that appear in a given range.
array:
Requires selection of a range to be evaluated.
[by_col]:
Optional argument. Indicated whether values in a row or a column should be evaluated.
[exactly_once]:
Optional argument. Allows flexibility by extracting a set of data that appears only once.