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?
|