Get a text reference from table

Fabisman

New Member
Joined
May 14, 2016
Messages
3
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.

ABCDEFGHIJ
0.52721025103
4557925135
683601925613
15282946157

<tbody>
</tbody>

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:)
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Something like this?
A​
B​
C​
D​
E​
F​
G​
H​
I​
J​
K​
L​
M​
N​
O​
1​
ABCDEFGHIJ
5​
2​
0.52721025103ICHJB
3​
4557925135EDBBB
4​
683601925613DEBAA
5​
15282946157AECJG
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,215,205
Messages
6,123,634
Members
449,109
Latest member
Sebas8956

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top