Explanation
This example uses theUNIQUE function.
With default tweaks, UNIQUE will output a list of unique values, i.e.
values that appear one or more times in the source data.
Related formulas
Unique values
Related functions
UNIQUE Function
Distinct values
To extract a list of distinct values from a set of data (i.e. values that appear just once), you can use the UNIQUE function. In the example shown, the formula in D5 is: =UNIQUE(B5:B16,FALSE,TRUE) which outputs the 2 distinct values in the data, "purple", and "gray".
