You can obtain a correctly formed Top 5 list with:

1. a pivot table or
2. a formula system.

For the latter, see my post in:

http://tinyurl.com/44ywo

owl527 wrote:
Hi, not only do I want to find the largest number, I actually want to
find the top 5 numbers.
this is what I put:
=("B"&3+MATCH(MAX(C4:C75),C4:C75,0))
I want to get the value in this cell (not the number itself but the
category the number belongs to). it is giving me the cell location, I
am unable to display the value in the cell. How do I do that? PLEASE
HELP! thanks!!!!