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

Returns the array of unique values in a list, table or cell range.

arrayThe range or array from which to return unique values.
by_col(Optional) Is a logical value indicating how to compare; By row = FALSE or omitted; By column = TRUE.
occurs_once(Optional) Is a logical value: only return unique values that occur once = TRUE; include all unique values = FALSE or omitted.


* This function is only available in Office 365 to Office Insiders at the moment.
* For the Microsoft documentation refer to support.office.com


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top