View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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?