Auto Ranking

[FinPro]

Hello

I have the following data:

[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64, align: left"]Co 1[/TD]
[TD="class: xl65, width: 64, align: left"]Co 2[/TD]
[TD="class: xl65, width: 64, align: left"]Co 3[/TD]
[TD="class: xl65, width: 64, align: left"]Co 4[/TD]
[TD="class: xl65, width: 64, align: left"]Co 5[/TD]
[TD="class: xl65, width: 64, align: left"]Co 6[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]22.20%[/TD]
[TD="class: xl67, align: right"]30%[/TD]
[TD="class: xl67, align: right"]10%[/TD]
[TD="class: xl67, align: right"]-50%[/TD]
[TD="class: xl67, align: right"]0%[/TD]
[TD="class: xl67, align: right"]11%[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65, align: left"]Ranking[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl68, align: left"]Co 2[/TD]
[TD="class: xl69, align: left"]Co 1[/TD]
[TD="class: xl70, align: left"]Co 6[/TD]
[TD="class: xl70, align: left"]Co 3[/TD]
[TD="align: left"]Co 5[/TD]
[TD="class: xl70, align: left"]Co 4[/TD]
[/TR]
</tbody>[/TABLE]


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...


[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

A​

[/td][td="bgcolor: #DCE6F1"]

B​

[/td][td="bgcolor: #DCE6F1"]

C​

[/td][td="bgcolor: #DCE6F1"]

D​

[/td][td="bgcolor: #DCE6F1"]

E​

[/td][td="bgcolor: #DCE6F1"]

F​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

Co 1​

[/td][td]

Co 2​

[/td][td]

Co 3​

[/td][td]

Co 4​

[/td][td]

Co 5​

[/td][td]

Co 6​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

22,20%​

[/td][td]

30%​

[/td][td]

10%​

[/td][td]

-50%​

[/td][td]

0%​

[/td][td]

11%​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

6​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

7​

[/td][td]

Ranking​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

8​

[/td][td]

1​

[/td][td]

2​

[/td][td]

3​

[/td][td]

4​

[/td][td]

5​

[/td][td]

6​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

9​

[/td][td]

Co 2​

[/td][td]

Co 1​

[/td][td]

Co 6​

[/td][td]

Co 3​

[/td][td]

Co 5​

[/td][td]

Co 4​

[/td][/tr]
[/table]

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.