Creating the formula for the top ten worked great! New issue:

How do I chose the aligned category or title of each of the chosen top
ten, so that I can include it in the chart I will make?

=LARGE($A$23:$A$57,1) through to =LARGE($A$23:$A$57,10) is what i
used.

The titles are in C23:C57

Thanks!!!

keith


--
hopeace
------------------------------------------------------------------------
hopeace's Profile: http://www.excelforum.com/member.php...o&userid=28009
View this thread: http://www.excelforum.com/showthread...hreadid=475930