standings

  • Thread starter Thread starter Kashyap
  • Start date Start date
K

Kashyap

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?
 
Kashyap said:
how to find out the standings of each? that is 1st or nd
or 3rd and so on?
Click to expand...

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 -----
 
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.
 
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?
Click to expand...

I'm assuming the numbers represent a timing situation, not actual
times of day. Either turn the numbers into a decimal value (like
"6.52") using

=VALUE(LEFT(D4,2))+(VALUE(RIGHT(D4,2))*0.01)

or if the number before the colon represents hours or minutes then

=VALUE(LEFT(D4,2))*60+(VALUE(RIGHT(D4,2)))

which will return an integer of the number of seconds or minutes.

Then use RANK as indicated above.

Regards,
Justin
 
Back
Top