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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I can not enter from the minimum time ( >=$Z$3, in my sheet.) Any more help.
Can send sheet if will help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND Nested Functions - Formula Not Working 0
assigning points to rankings 9
Calculating a Formula Subject to a Maximum and Minimum Value 2
Sumproduct but only first time corresponding value is seen e.g. un 1
Time difference calculation 2
Matching times and classes 5
Make a cell not equal less than a certain number 5
Delete rows if time is greater than present time 2

Back
Top