The UNIQUE function in Excel is a function that returns a list of unique values from a range of cells or an array. It is particularly useful when you want to extract a list of unique values from a large dataset, or when you want to identify duplicates in a dataset.
Here is the syntax for the UNIQUE function:
UNIQUE(array, [by_col], [exclude_or_include_hidden_rows])
array argument is the range of cells or array that you want to extract unique values from. The
by_col argument is optional and specifies whether the function should consider each row or each column as a separate entity. If
by_col is set to TRUE, the function will consider each column as a separate entity, and if it is set to FALSE, the function will consider each row as a separate entity. The
exclude_or_include_hidden_rows argument is also optional and specifies whether to include or exclude hidden rows from the list of unique values.
Here is an example of how you might use the UNIQUE function in a formula:
This formula would extract a list of unique values from the range A1:A10.