How to make a ranking formula but starting from negative numbers and preventing double rankings
SCORE | RANK |
---|---|
-50 | 1 |
-25 | 2 |
-20 | 3 |
-10 | 5 |
-20 | 4 |
-10 | 6 |
-1 | 7 |
0 | 8 |
3 | 10 |
1 | 9 |
here is the link : https://docs.google.com/spreadsheets/d/1OG7lCRVDu_BFVU2F8bPokAeX3iS61HlzuWkL1JwkVRM/edit?gid=0#gid=0
I tried the formula but it didn't work as I expected =RANK(A2,$A$2:$A)