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

[@lakeline6317]

Thanks for this. Is very useful.

[@batukbhairavnath4399]

Great Sir

[@xlwatcher8885]

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

[@sgari1974]

Use countif.. =countif(unique(A2:A5),"20")

[@pip_pamp]

thanks i freaking need this @@sgari1974

[@quercus56]

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

[@Techno_Chat]

Why are you not Uploading Brother ?

[@laxmigovind7368]

How to use countif added to above formula

[@sgari1974]

Countif(Unique(A2:A5),"20")

[@Topa06]

not useful

[@extraemilysus]

20 is duplicate not unique

[@shon_-_]

The first 20 is unique. Depends on how you want to categorize/count.