Formula for placings, using 4 times and greater than minimum time

H

handers

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

Jason Morin

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
 
H

handers

I can not enter from the minimum time ( >=$Z$3, in my sheet.) Any more help.
Can send sheet if will help.
 
Top