Counting unique values in Excel – 5 effective ways

Counting unique values in Excel – 5 effective ways

13 August 2018

A very common requirement is to count only the unique occurrences of some values. But Excel doesn't have a direct way to count unique values.

In this post we show 5 different ways of counting unique values in Excel:

  • SUMPRODUCT and COUNTIF
  • SUM, FREQUENCY and MATCH array formula
  • PivotTable
  • SUM and COUNTIF
  • COUNTUNIQUE user defined function