View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
rousseau
 
Posts: n/a
Default Show figures and dates for "top ten"


I apologize if this has been asked before, but I couldn't find anything
with a search.

I have a table with monthly revenues. The headings across the top have
the years, from 2000 to 2006. The headings at the side have the months,
from January down to December.

I'm clear on how to show the top ten months for revenues using the
LARGE function. What I'd like to do is show the month and year, as
well. Could anyone point me to a solution?

Many thanks!
Rousseau


--
rousseau
------------------------------------------------------------------------
rousseau's Profile: http://www.excelforum.com/member.php...o&userid=33013
View this thread: http://www.excelforum.com/showthread...hreadid=528374