Sheets Unique
How to get unique values from range of cells
Use the UNIQUE()
formula in Google sheets.
Example
=UNIQUE(A1:A10)
The UNIQUE() formula accepts a range of cells and filters out the duplicates and returns that range.
Source: https://webapps.stackexchange.com/questions/76380/get-unique-values-from-range-of-cells
Written on March 17, 2020