Try this:

=RANK(B2,B$2:B$6)+SUMPRODUCT(--(B2=B$2:B$6),--(C2C$2:C$6))

This could still result in ties if both column B and C are the same:

Name1 100 72
Name4 100 72

Biff

wrote in message
oups.com...
I am trying to come up with a function to rank finishes and break ties
based off two columns.

An example of the worksheet would be:

A B C D
1 NAME DISTANCE TIME RANK
2 Name1 100 72 tie
3 Name2 100 65 tie
4 Name3 85 60 4
5 Name4 79 40 5
6 Name5 100 92 tie


They must cover a distance in the fastest time to win. I am having
trouble figuring the ties using column C (TIME) which should be the
lower time wins. I would like to use formulas if possible to update
the worksheet instantly.

Thanks in advance.

-Gary