set of a set of cells with
=large(range,1)
to
=large(range,10)
this will give you the top ten in order
"hopeace" wrote:
I have a list of totals, around 25. I only want to chart a selection of
these totals- only the top 10.
I'm creating this spreadsheet for a group of non-techie school
counsellors. Can this whole process of sorting be automated? I know how
to make the chart, I'm just stuck on where do i get the top ten list.
Thank you so much for reading! Mutual help fourms and communities are
awesome!!!
keith
--
hopeace
------------------------------------------------------------------------
hopeace's Profile: http://www.excelforum.com/member.php...o&userid=28009
View this thread: http://www.excelforum.com/showthread...hreadid=475930