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