Returns a list of unique values in the provided range.
- range - The range of cells to be examined.
UNIQUE(C5:C15) returns all the unique values in the range C5:C15.
- If rows are returned which appear to be duplicates, ensure that cells including text do not have differing hidden text such as trailing spaces.
- Ensure that numeric values are formatted in the same way - percentages as percentages, currency values as currency values, etc.