Rank Formula NOt Fully Working

[muhammad susanto]

hi all...

i have table :

score	ranking - order
20000	1
1500	2
140	3
120	4
100	5
99	6
96	7
96	7
78	9

<thead>
</thead><tbody>
</tbody>

for line 96 (duplicate) should be ranking is 8 not 7

formula : =RANK(F3;$F$3:$F$50)
any helps, thanks all..

m.susanto

 

[AliGW]

That's not how ranking works. Have a look here: http://www.mrexcel.com/forum/excel-questions/448361-unique-rank-tie-breaker.html