What does the UNIQUE function return?
- A A spilled list of distinct values from a range
- B The count of unique values
- C The first value in a range
- D A sorted range
Answer
A spilled list of distinct values from a range
UNIQUE combined with SORT and FILTER replaces much of what previously required PivotTables or advanced filters.





