Hi All,
I have a competition score recap where the highest scoring group is called the "Sweepstakes Winner" and the 2nd place group is considered 1st place.
I'd like to use the =Rank formula but have the highest score rank be "SS" and then the 2nd highest score be 1st etc.
Sample is below.
Thanks,
-Tony
Excel 2010
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
I have a competition score recap where the highest scoring group is called the "Sweepstakes Winner" and the 2nd place group is considered 1st place.
I'd like to use the =Rank formula but have the highest score rank be "SS" and then the 2nd highest score be 1st etc.
Sample is below.
Thanks,
-Tony
Excel 2010
A | B | C | D | |
---|---|---|---|---|
1 | Scores | Ranks | Desired Result | |
2 | Group A | 96 | 3 | 2 |
3 | Group B | 94 | 5 | 4 |
4 | Group C | 99 | 1 | SS |
5 | Group D | 97 | 2 | 1 |
6 | Group E | 95 | 4 | 3 |
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>