Using RANK twice in a formula

[keawyed]

I am currently running my own predictions league and can rank the teams in order of their Points total, but the problem is when points are equal, how do I separate them?
I want to separate by Points Scores, then by % of correct results.

For example if I have 2 players on 30 points; Player 1 has 55% correct, Player 2 has 50% correct,then Player 1 is top.

I have enclosed an example of the final table.
Rankings are obtained using a 'vlookup' from a separate worksheet.

Thankyou, as always, for your continued assistance.

Regards, Craig

[daddylonglegs]

Try this formula in A2 copied down

=SUMPRODUCT(--(G$2:G$5+H$2:H$5>G2+H2))+1

[keawyed]

Thankyou DLL for the reply.
However, I am using imaginary bets and earnings to separate equal points and the formula doesn't work as you will see from the example.
Players with less points are above others, because their earnings are more.
I want it so points are used first to separate; then earnings to split them.
Hope you understand.

Are you possibly able to tweak it for me please?

Thanks as always for your continued assistance.

Craig

[shg]

In A2 and copy down, try

=RANK(G2, $G$2:$G$17) + SUMPRODUCT( (G2 = $G$2:$G$17) * (H2 < $H$2:H$17) )

A month is a bit long to respond, considering that DLL responded in 10 minutes to your original post.

[keawyed]

Dear SHG,

Apologies for the time delay.

When I originally had the problem, I tried it with fewer players and this problem didn't appear.

Please don't think I don't appreciate all help from you or any of the Administrators.

Regards,

Craig

[shg]

When I originally had the problem, I tried it with fewer players and this problem didn't appear.

That would have been a good opportunity to thank DLL for his help, huh?

Ditto in threads http://www.excelforum.com/excel-work...ns-league.html and http://www.excelforum.com/excel-work...yet-again.html where you never responded.

And in thread http://www.excelforum.com/excel-work...ns-league.html where you never responded to Richard Buttrey.

And in thread http://www.excelforum.com/excel-work...edictions.html where you never responded to Gearcutter.

That's every thread you've started, less one. You could find this forum very quiet place.