MS.UNIQUE2
Description
Returns the unique values in a specified array. This function is intended for use with unconstrained arrays. To submit the formula, use the unconstrained keyboard shortcut Ctrl+Alt+Enter (Windows) or Command+Option+Enter (Mac). MS.UNIQUE2 is case-insensitive.
Syntax
MS.UNIQUE2(
array
, [ by_col
], [ exactly_once
]) - array: The array to extract unique row or column values from.
- by_col: A logical value that specifies how to do the comparison. Specify TRUE to compare columns against each other and return the unique columns. Specify FALSE to compare rows against each other and return the unique rows. The default is FALSE.
- exactly_once: A logical value that specifies whether to return only rows or columns that occur exactly one time. Specify TRUE to return distinct rows or columns that occur exactly one time. Specify FALSE to return all distinct rows or columns. The default is FALSE.
Related Functions
UNIQUE2
DISTINCTROWS2