UNIQUE Function
Purpose
Returns an array of distinct or unique values from a specified list or range.
Syntax
EXCEL
=UNIQUE(array, [by_col], [exactly_once])
Returns an array of distinct or unique values from a specified list or range.
=UNIQUE(array, [by_col], [exactly_once])