Try this:

=SUMPRODUCT((A1:A6<"")/COUNTIF(A1:A6,A1:A6&""))

Biff

"MK" wrote in message
...
Hi, I am new to excel and wonder if anyone can help me with count.

I have a table e.g

aaa
aaa
bbb
bbb
ccc
ccc

I want to count the numbers of text or numbers in the column without the
repeated text or numbers. i.e the result should be 3 not 6. I need the
count
to be able for number as well.