Try this (lightly tested):

=RANK(D2,D$2:D$5)+SUMPRODUCT(--(D2=D$2:D$5),--(B2+C2<B$2:B$5+C$2:C$5))

Assumes no empty cells. Each competitor has 2 scores to rank.

--
Biff
Microsoft Excel MVP


"Marc Shaw" wrote in message
...
Here is a sample of the data that I am working with:
Skier Round 1 Round 2 Best Round
Competitor 1 109 105.5 109
Competitor 2 104 109 109
Competitor 3 107.5 107.5 107.5
Competitor 4 104.5 107 107

I am using the column "Best Round" to rank the skiers after they have
completed 2 rounds of competition. I am using the Rank function to create
my
list however where the problem comes in is where 2 skiers have the same
"Best
Round" I need the formula to be able to look at their other score to see
which skier has the best backup score and rank them higher. Any
suggestions
would be greatly appreciated

Thanks,
Marc Shaw