thenapolitan
Board Regular
- Joined
- Sep 5, 2014
- Messages
- 52
Hi All,
I understand the idea of using something like this where Column C = RANK(A1,$A$1:$A$8,1) & Column D =RANK(A1,$A$1:$A$8,1)+COUNTIF($A$1:A1,A1)-1
But what I really want is to order the rank data without skipping a number, such as Column E.
<colgroup><col span="5"></colgroup><tbody>
</tbody>
Any ideas on how to do this?
Thanks,
Chris
I understand the idea of using something like this where Column C = RANK(A1,$A$1:$A$8,1) & Column D =RANK(A1,$A$1:$A$8,1)+COUNTIF($A$1:A1,A1)-1
But what I really want is to order the rank data without skipping a number, such as Column E.
ColumnA | ColumnB | ColumnC | ColumnD | ColumnE |
2 | 2 | 1 | 1 | 1 |
3 | * | 2 | 2 | 2 |
3 | 1 | 2 | 3 | 2 |
4 | 5 | 4 | 4 | 3 |
5 | 5 | 5 | 5 | 4 |
6 | 5 | 6 | 6 | 5 |
7 | 5 | 7 | 7 | 6 |
8 | 5 | 8 | 8 | 7 |
<colgroup><col span="5"></colgroup><tbody>
</tbody>
Any ideas on how to do this?
Thanks,
Chris