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?

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?

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?