Rank Formula with multiple Criteria (Bowling Total Score and 3 games)

Hi all,

I have been searching the forum for assistance on this and some of the answers that I have found have come close.

I am trying to create a formula to rank bowlers based on their (1) Total score.

If this results in a tie between two or more bowlers, the score of the 1st game would be used to break the tie (whichever bowler scored higher).

This is then carried forward to the 2nd and 3rd game if the tie is not broken by the 1st game.

Seeking your help on this, please!

Regards,
Joseph

Pl see file
Formuala

Please Login or Register  to view this content.

Thank you very much =)

This works great!