Thread: standings
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default standings

use RANK()

=RANK(B2,B2:B6,1)

Depending on which order you want the rank to go, may want to use 0 instead
of 1.

"Kashyap" wrote:

Jean 06:52
Jackson 05:12
UmaU 00:00
Peter 05:36
Joseph 02:48

in the above table how to find out the standings of each? that is 1st or nd
or 3rd and so on?