How to Count Unique Values in Google Sheets (With Examples)


Often you may want to count the number of unique values in Google Sheets.

Fortunately this is easy to do using the COUNTUNIQUE() function.

The following examples show how to use this function in practice.

Example 1: Count Unique Values in One Column

The following screenshot shows how to use the COUNTUNIQUE() function to count the number of unique team names in column A:

There are 6 unique team names in column A.

Example 2: Count Unique Values in Multiple Columns

The following screenshot shows how to use the COUNTUNIQUE() function to count the number of unique team names in column A and column B:

There are 13 unique team names in column A and column B.

Example 3: Count Occurrences of Unique Values

To count how often each unique value occurs, you can first use the UNIQUE() function to display a list of unique team names:

You can then use the COUNTIF() function to count how often each unique team name occurs in column A:

From the output we can see:

  • Mavericks occurs 2 times.
  • Hornets occurs 3 times.
  • Nets occur 1 time.

And so on.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

How to Calculate Frequencies in Google Sheets
How to Sum Values by Category in Google Sheets
How to Count Number of Occurrences in Google Sheets

Leave a Reply

Your email address will not be published.