Rankif?

The previous formula works fine when you want to rank from maximum value (= ranking no. 1) to minimum value (ranking 'n')

What I want to do is to rank the results in a time trial, where the winner is the person with the smallest time

I have no idea how the formula below works (but I can see that it does work on sample data that I am using for testing); can anyone help so that the ranking works in reverse to the formula below?

Many thanks

Piers

Sorry - I forgot to say that I am using Excel 2007 (if that makes any difference)

Piers

I have sorted this through a bit of trial and error

By switching the '>' to '<' in the second set of brackets, this reverses the sortation order from smallest-to-largest

Not sure how, but it does it!