I am needing help on a formula that ranks a set of cells. some will have data and some will not depending on the time the report is ran. I am attempting to exclude the data with zeros and no data from the rankings.
Current formula used : =IF(Q6=0,"",RANK(Q6,$Q$6:$Q$20,1))
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Current formula used : =IF(Q6=0,"",RANK(Q6,$Q$6:$Q$20,1))
Points | Rank2 |
10 | 9 |
12 | 10 |
16 | 13 |
12 | 10 |
18 | 14 |
14 | 12 |
27 | 15 |
0 | |
0 | |
0 | |
0 | |
0 | |
0 | |
0 | |
0 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>