On Mon, 10 Mar 2008 22:20:30 -0700 (PDT), Lan Mind wrote:

----------------------------------
5In the upper left cell I entered:
=transpose(uniquecount(rng))
------------------------------------


Does "rng" refer to the range containing your text to be analyzed?

For example, if your text is in A1:A10, then you can either NAME
(Insert/Name/Define) rng as refers to: A1:A10, or substitute that in the
formula.
--ron