Counting unique values in Excel – 5 effective ways

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