Well, with that function I'd have to specify WHAT I want it to count such as
a function for dog, one for cat, etc... I just want excel to compile a list
of everything that was in the table with the # of times it appears in the
table without having to write a function for each entry, you understand?
have a suggestion? THANKS!

"Barb Reinhardt" wrote:

Have you tried the COUNTIF function?

"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