Skip to content

Count the Unique Values in a List

In this article, you will learn how to count the number of unique values in a list.

This method works for both Microsoft Excel and Google Sheets.

How to Count the Unique Values

You will combine the UNIQUE function with the COUNTA function to count the unique values within your list.

The UNIQUE function will return all of the unique values within your list. Then the COUNTA function will count how many values there are.

As a result, you end up with a count of the unique values within your list.

See An Example

Here is an example in Google Sheets. You have a list of colors and want to know how many unique values there are.

You write the following formula to count the unique values.

=COUNTA(UNIQUE(A1:A8))

The UNIQUE function calculates first and returns only the unique values from the list of colors. This array then passes to the COUNTA function, which counts how many values there are.

In the end, you end up with a count of the unique colors within your list.

And that is how you can use the COUNTA and UNIQUE functions to count the unique values in a list.

This Post Has 2 Comments

  1. This is honestly super helpful! I could think of a lot of spreadsheets I could use this in! I noticed that the example was in Google sheets, but will this also work in Excel?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top