Hi,
I have a list which the items were ranked by me according to different parameters.
now I've decided to change the ranking of few, and I need to excel to change all rankings accordingly.
For example, if no 5 became number 1, than no. 1 should be ranked no. 2 and so on.
I've tried to think of some formula that will give different score to each item, but got confused....
How can I get "new rank" automatically?
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I have a list which the items were ranked by me according to different parameters.
now I've decided to change the ranking of few, and I need to excel to change all rankings accordingly.
For example, if no 5 became number 1, than no. 1 should be ranked no. 2 and so on.
I've tried to think of some formula that will give different score to each item, but got confused....
How can I get "new rank" automatically?
Name | Original Rank | Rank Update | new rank |
A | 1 | 3 | |
B | 2 | 4 | 4 |
C | 3 | 8 | |
D | 4 | 6 | 6 |
E | 5 | 9 | |
F | 6 | 5 | 5 |
G | 7 | 1 | 1 |
H | 8 | 10 | |
I | 9 | 7 | 7 |
J | 10 | 2 | 2 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>