Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more
In Google Sheets, the UNIQUE function is a built-in function that returns a list of unique values from a specified range. Here is the breakdown of the function's arguments:
range: This is the range of cells from which you want to extract unique values. It can be a single column or a range that includes multiple columns.
by_column (optional): This argument is a logical value that determines how the uniqueness is evaluated when using a range with multiple columns. If set to TRUE or omitted, uniqueness is evaluated by column-wise comparisons. If set to FALSE, uniqueness is evaluated by row-wise comparisons.
exactly_once (optional): This argument is also a logical value that specifies whether values that appear only once in the range should be included in the result. If set to TRUE or omitted, only values that appear more than once will be included. If set to FALSE, all unique values, including those that appear only once, will be included.
The UNIQUE function is useful for extracting distinct values from a range, such as removing duplicates or creating a list of unique items. It dynamically updates as the source range changes.
Here's an example usage of the UNIQUE function: =UNIQUE(A1:A10, TRUE, TRUE)
This formula would return a list of unique values from cells A1 to A10, considering column-wise comparisons and excluding values that appear only once.