Get a text reference from table

[Fabisman]

Hi. i'm currently working on my bachelor thesis and i'm now trying to create a formula that gives me the "header", after it has identified the largest number in the set and give me the column header as a answer.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]0.5[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]10[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD]60[/TD]
[TD]19[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]2[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD]9[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

So what i'm trying to do is to get the formula to identify (in the first row with numbers) 10 as the largest number on the row, and then give me I in a new cell somewhere on the sheet, and so on for the Nth largest numbers i need. Also on the other rows. Is there anyway to do this? tried with hlookup and other formulas, but it won't give me the text.. is there also a possibility to make the letters have a value? e.g F=0,876? and get that in the goalcell? Any tips would be much appreciated. Thx

 

[Fabisman]

And the letters is the heading for the table, not columns in general

 

[FDibbins]

Something like this?
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][td]

H​

[/td][td]

I​

[/td][td]

J​

[/td][td]

K​

[/td][td]

L​

[/td][td]

M​

[/td][td]

N​

[/td][td]

O​

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

1​

[/td][td]A[/td][td]B[/td][td]C[/td][td]D[/td][td]E[/td][td]F[/td][td]G[/td][td]H[/td][td]I[/td][td]J[/td][td]

5​

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

[tr][td]

2​

[/td][td]0.5[/td][td]2[/td][td]7[/td][td]2[/td][td]1[/td][td]0[/td][td]2[/td][td]5[/td][td]10[/td][td]3[/td][td]I[/td][td]C[/td][td]H[/td][td]J[/td][td]B[/td][/tr]

[tr][td]

3​

[/td][td]4[/td][td]5[/td][td]5[/td][td]7[/td][td]9[/td][td]2[/td][td]5[/td][td]1[/td][td]3[/td][td]5[/td][td]E[/td][td]D[/td][td]B[/td][td]B[/td][td]B[/td][/tr]

[tr][td]

4​

[/td][td]6[/td][td]8[/td][td]3[/td][td]60[/td][td]19[/td][td]2[/td][td]5[/td][td]6[/td][td]1[/td][td]3[/td][td]D[/td][td]E[/td][td]B[/td][td]A[/td][td]A[/td][/tr]

[tr][td]

5​

[/td][td]15[/td][td]2[/td][td]8[/td][td]2[/td][td]9[/td][td]4[/td][td]6[/td][td]1[/td][td]5[/td][td]7[/td][td]A[/td][td]E[/td][td]C[/td][td]J[/td][td]G[/td][/tr]
[/table]
K1 = N
K2=IF(COLUMNS($A$1:A1)>$K$1,"",INDEX($A$1:$J$1,MATCH(LARGE($A2:$J2,COLUMNS($A$1:A1)),$A2:$J2,0)))
copied down and across as needed

 

[Fabisman]

Yey, it works! thank you if i want to tweak the formula a little so that it sums e.g the rows 2,3,4 and gives me the highest value...which in this case would be 1D (since the three rows beneath sums up to the largest number) what should i do then? thx