If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
standings
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
standings
On Jun 11, 1:06*pm, 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? 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 |
Thread Tools | |
Display Modes | |
|
|