Manual ranking a list

[oferav]

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?

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>

 

[Snakehips]

oferav,

Try the following Array formula. (Confirm with Ctrl + Shift + Enter and Excel will add the curly braces)

Excel Workbook
	A	B	C	D
1	Name	Original Rank	Rank Update	new rank
2	A	1	*	3
3	B	2	4	4
4	C	3	*	8
5	D	4	6	6
6	E	5	*	9
7	F	6	5	5
8	G	7	1	1
9	H	8	*	10
10	I	9	7	7
11	J	10	2	2
Sheet2

Hope that helps.

 

[oferav]

Works great!!! TNX