Ralph wrote:
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

You might be looking for something like the one my post describes in:

http://www.mrexcel.com/board2/viewtopic.php?t=115570