View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Calculating Top 5

Lookup RANK in help, the explanation should suffice


Regards,

Peo Sjoblom


"rdusseau" wrote:


Hi all,

I have a set of data (a score or time from a school olympic day) and I
would like to be able to automatically rank the top 5 participants on
another worksheet. Any thoughts on how to do that?

Thanks,
Rob


--
rdusseau
------------------------------------------------------------------------
rdusseau's Profile: http://www.excelforum.com/member.php...o&userid=15140
View this thread: http://www.excelforum.com/showthread...hreadid=545324