I'm afraid that was not exactly what I mean.

Let say some cells in range (A1:M50) contained words "happy", "birthday",
"new year", "anniversary", etc.
All I wanted to do is to list down all the words in a separate area or
column. The result should be as follows:

1. anniversary (1)
2. birthday (1)
3. happy (5)
4. new year (1)

And if possible I want the result also sort automatically.

Thanks in advance.



"Gary''s Student" wrote in message
...
In N1 enter:
=OFFSET(A$1,ROUNDUP(ROW()/13,0)-1,MOD(ROW()-1,13)) and copy down

this will produce a list of the contents of A1 thru M50 in a single
column.

Let's assume that the cells in the table contain either a single word or
are
blank. The count of the words is:

=COUNTIF(A1:M50,"<" & "")

--
Gary''s Student - gsnu200831


"milo" wrote:

Hi.

how do I create a list of words and count them as well using formula?
I have cell range (A1:M50) that contain words.

Thanks in advance.