Hello All,
Im sure you will be able able to help with the following question:
I am trying to RANK a list of data but where the number maybe the same how can i get the formula to not have duplicates... So far example below i want James to be ranked 4th and Sally 5th even though they both had the same score
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I would really appreciate your support and advice on this
=RANK.EQ(C3,$C$3:$C$7,0)
Many thanks
Steve
Im sure you will be able able to help with the following question:
I am trying to RANK a list of data but where the number maybe the same how can i get the formula to not have duplicates... So far example below i want James to be ranked 4th and Sally 5th even though they both had the same score
Name | Score | Rank |
Scott | 100 | 1 |
James | 59 | 4 |
Sally | 59 | 4 |
Beth | 99 | 2 |
David | 60 | 3 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
I would really appreciate your support and advice on this
=RANK.EQ(C3,$C$3:$C$7,0)
Many thanks
Steve