Count unique values

[Bmcosta]

Hi,

I need to count the unique values of a column.

For example:
Column A
c022
c021
c023
c022
c021
c024

The count that I pretend is = 4

Any assistance will be appreciated.

Thanks.
Bruno Costa

 

[JulieD]

Hi

check out
http://www.cpearson.com/excel/duplicat.htm

there's a section called counting unique entries about half way down the
page

Cheers
JulieD

 

[Andy B]

Hi

Have a look here:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique

 

[Peo Sjoblom]

=SUM(IF(A1:A20<>"",1/COUNTIF(A1:A20,A1:A20)))

entered with ctrl + shift & enter

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom

 

[bmcosta]

Thanks Andy B, JulieD and Peo Sjoblom for the tips.

I just have one more doubt ... what is "entered with ctrl
+ shift & enter" ?

 

[Frank Kabel]

Hi
the complete formula. Just insert your formula and instead of hitting
onl yENTER hit CTRL+SHIFT+ENTER. This way you create an array formula.
See:
http://www.cpearson.com/excel/relative.htm

 

[Harlan Grove]

...
...

See:
http://www.cpearson.com/excel/relative.htm

...

I believe you meant

http://www.cpearson.com/excel/array.htm

 

[Frank Kabel]

...
..
..

I believe you meant

http://www.cpearson.com/excel/array.htm

Hi Harlan
yes, thanks for the correction
Frank