Are you familiar with Excel’s Unique function?
This new Excel function returns a list of unique values in a list or range, and is particularly useful when summarising data.
In the latest episode of our Excel how-to series, we’ll show you exactly how to use the Unique function to:
- Extract unique entries in a list for analysis
- Identify data that only occurs once in a list
- Create a summary formula that responds to changes in the list
We’ll also be guiding you through the three arguments of the Unique function.