Couting occurences of different text

Giganews Newsgroups
Subject: Couting occurences of different text
Posted by:  PG (paul.gal…@verizon.net)
Date: 1 Oct 2003

Hello Excelers,

I have a column of text similar to the one shown below.  I am trying
to find a way to oount the number of different occurences.  In this
case, I have AAA, BBB, CCC, DDD and SSS so I am looking for a function
that would return 5.  I dont want to know the number of each, just the
number of different values.

Any help would be greatly appreciated.

Paul

AAA
BBB
AAA
BBB
CCC
DDD
AAA
AAA
SSS

Replies