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.
<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
A | B | C | D | E | F | G | H | I | J |
0.5 | 2 | 7 | 2 | 1 | 0 | 2 | 5 | 10 | 3 |
4 | 5 | 5 | 7 | 9 | 2 | 5 | 1 | 3 | 5 |
6 | 8 | 3 | 60 | 19 | 2 | 5 | 6 | 1 | 3 |
15 | 2 | 8 | 2 | 9 | 4 | 6 | 1 | 5 | 7 |
<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