I'm trying to create a formula to rank the following from lowest to highest with a tie breaker. So far I've come up with this:
=RANK(X2,X$2:$X21,0) but it does not work and does not account for a tie.
Column X
<colgroup><col></colgroup><tbody>
</tbody>
Any help is appreciated.
=RANK(X2,X$2:$X21,0) but it does not work and does not account for a tie.
Column X
0.17 |
3.33 |
2.50 |
0.83 |
0.58 |
3.33 |
1.00 |
<colgroup><col></colgroup><tbody>
</tbody>
Any help is appreciated.