How to Count Unique Values in Excel | How to Use the COUNTA and UNIQUE Functions

In this video, we’ll show you How to Count Unique Values in Excel.

Microsoft Excel has a lot of useful functions, but today we’ll show you how to calculate unique values and their quantity.

Let’s go through the steps!

Open your spreadsheet.
Let’s suppose that we have a set of values entered in cells A1 through A5.
Use this formula to find out all the unique values:
=UNIQUE(A1:A5) and press the enter button.
You will see all the unique values.
Now if you want to find out the total number of unique values, then use this formula.
=COUNTA(UNIQUE(A1:A5)) and press enter.
Now you can see all the unique values in your list.

That’s it!

❓💬 What other tips do you want to know? Let us know in the comments below.

#HowTech #excel
--------------------------------------------------------------------------------------------------------------

[xlwatcher]

Thank you! Great vid. I am trying to do this: I need to know how many times each of the unique items occurred. Is there a way for =Unique to specify that there were two 20s, and 1 of everything else.? Thanks

[quercus]

Or use Google sheets, which has a countunique formula option - when is Excel going to get this?

[laxmigovind]

How to use countif added to above formula