Type this to B3, and then pull it to the rest of the rows:
=IF(C3=C2,B2,B2+COUNTIF($C$1:$C3,C2))
What it does is:
- If my points equals the previous points, I have the same position.
- Othewise count the players with the same score as the previous one, and add their numbers to the previous player's position.