UNIQUE Function Explained
The UNIQUE function in Microsoft Excel returns a list of unique values from a range or array. It can be used to identify and extract unique values from a range of cells, or to create a list of distinct values from multiple ranges. It can also be used to compare two or more ranges and return the unique values from each range.
UNIQUE Function Syntax
UNIQUE(array, [by_col], [exactly_once])
- array: The range of cells or array to be evaluated.
- by_col: (Optional) A logical value that specifies whether to return unique rows (FALSE) or unique columns (TRUE).
- exactly_once: (Optional) A logical value that specifies whether to return only values that occur exactly once (TRUE) or all unique values (FALSE).