Auto Ranking

[FinPro]

Hello

I have the following data:

Co 1	Co 2	Co 3	Co 4	Co 5	Co 6
22.20%	30%	10%	-50%	0%	11%
Ranking
1	2	3	4	5	6
Co 2	Co 1	Co 6	Co 3	Co 5	Co 4

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>

When the data on top under "Co1 Co2 etc" changes, based on some input, the ranking below should be automatically updated.

Thanks for your help in advance.

 

[Marcelo Branco]

Maybe...

	A​	B​	C​	D​	E​	F​
1​	Co 1​	Co 2​	Co 3​	Co 4​	Co 5​	Co 6​
2​	22,20%​	30%​	10%​	-50%​	0%​	11%​
3​
4​
5​
6​
7​	Ranking​
8​	1​	2​	3​	4​	5​	6​
9​	Co 2​	Co 1​	Co 6​	Co 3​	Co 5​	Co 4​

Formula in A9 copied across
=INDEX($A$1:$F$1,MATCH(LARGE($A$2:$F$2,A$8),$A$2:$F$2,0))

M.

 

[FinPro]

Thanks Marcelo. This worked perfectly.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.