Maybe not exactly what you're looking for, but ...

You could enter this formula in the column adjacent to the datalist, which
will simply display the count of every item in the table:

=COUNTIF($A$1:$A$100,A1)

And copy down.

Then, this formula will give you a count of the unique items in the table:

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

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Ralph" wrote in message
...
Hi,

Is there a way to select a table and have excel produce a list ranking the #
of times each item shows up in the list, i.e.

dog 5
cat 2
bird 1
???

Thanks