Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for placings, using 4 times and greater than minimum time
Excel 2003.
I am trying to work out a formulae for placings in a race. There will be four times entered and they will only be placed (1st 2nd etc,) if the go over the minimum time. My brain has given up. Any ideas? |
#2
|
|||
|
|||
With the 4 times in A1:A4 and the min. time in C1, place this in B1 and copy
down to B4: =IF(A1<$C$1,"",RANK(A1,IF($A$1:$A$4=$C$1,$A$1:$A$ 4),0)) HTH Jason Atlanta, GA "handers" wrote: Excel 2003. I am trying to work out a formulae for placings in a race. There will be four times entered and they will only be placed (1st 2nd etc,) if the go over the minimum time. My brain has given up. Any ideas? |
#3
|
|||
|
|||
I can not enter from the minimum time ( =$Z$3, in my sheet.) Any more help.
Can send sheet if will help. "Jason Morin" wrote: With the 4 times in A1:A4 and the min. time in C1, place this in B1 and copy down to B4: =IF(A1<$C$1,"",RANK(A1,IF($A$1:$A$4=$C$1,$A$1:$A$ 4),0)) HTH Jason Atlanta, GA "handers" wrote: Excel 2003. I am trying to work out a formulae for placings in a race. There will be four times entered and they will only be placed (1st 2nd etc,) if the go over the minimum time. My brain has given up. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add up a range of times giving answer in hrs & mins >24h. | Excel Worksheet Functions | |||
what should i use | Excel Worksheet Functions | |||
Subtracting Times | Excel Worksheet Functions |