Thread: Count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MK MK is offline
external usenet poster
 
Posts: 57
Default Count

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.