Hi,

I have an excel sheet with scores from four rounds of a game. Excel file can be downloaded HERE for your reference.

What I am trying to do is to calculate the Position of the player based on the total score. I have calculated it up to the the players who played and finished the game. Then there is a blank line and then listed are the players who didn't finish the game.

The problem is, the scores for some players are equal, and they fall in the same position. For example, if 4 players have the score 274, they all fall in 10th Position, but as soon as there is a next level, the next player is positioned at number 14 and not 11. I am more interested in a formula for the players who didn't finish the game because I have already worked it around for the players who finished the game (however, please examine the formula, suggestions are welcome, also, I would like the result to be a number and not text, as my formula is doing).

Thanks in Advance.

Zeeshan