Thread: standings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default standings

"Kashyap" wrote:
how to find out the standings of each? that is 1st or nd
or 3rd and so on?


Depending on which you consider 1st -- lowest or highest -- try one of the
following in B1 and copy down:

=rank(B1,$B$1:$B$5)

=rank(B1,$B$1:$B$5,1)


----- original message -----

"Kashyap" wrote in message
...
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?