i-nth - 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

Full article: Counting unique values in Excel – 5 effective ways

Essential reading

Spreadsheet methodology

Our spreadsheet methodology has criteria for designing, building, and validating spreadsheets to ensure that they work correctly.

Latest articles

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.