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.