Singling out a value

[woodsyguy81]

Hi everyone,
I'm familiar with Excel, but always learning something new. Here is my dilemma:
I want to be able to take the highest number in the row and call out its column heading in a seperate cell. (ex. the highest number in O3:Q3 is 2 which is in the "Medium" column so the cell would be equal to "Medium"). See attached jpeg for details. Any ideas?

[Bryan Hessey]

The only number in Q3:Q3 is 2.

I presume that you wanted the highst number from O3:Q3, - by column it was
=OFFSET($A1,MATCH(LARGE(B1:B10,1),B1:B10,0)-1,0)

by row hopefully

=OFFSET($O$1,0,MATCH(LARGE(O3:Q3,1),O3:Q3,0)-1)

but it's 2:00am, and if that doesn't work I'll fix it tomorrow.

---

Hi everyone,
I'm familiar with Excel, but always learning something new. Here is my dilemma:
I want to be able to take the highest number in the row and call out its column heading in a seperate cell. (ex. the highest number in O3:Q3 is 2 which is in the "Medium" column so the cell would be equal to "Medium"). See attached jpeg for details. Any ideas?

[woodsyguy81]

Thanks for the help, although it didn't seem to work out in my table. I'll keep playing with that formula and try to get it to work out. Till then get some sleep! Anyone else have any other ideas?

UPDATE: Bryan, thanks for the help! I figured out how to get the value I wanted using some of your formula and a lot of trial and error! =INDEX($O$2:$Q$2, MATCH(LARGE(O3:Q3,1),O3:Q3,0))

[Bryan Hessey]

Of course, the original reference point should be O3, not O1, thus
=OFFSET($O$3,0,MATCH(LARGE(O3:Q3,1),O3:Q3,0)-1)
or
=OFFSET($O$1,2,MATCH(LARGE(O3:Q3,1),O3:Q3,0)-1)
are correct, but good to see you got it working, and thanks for the response.

---

Thanks for the help, although it didn't seem to work out in my table. I'll keep playing with that formula and try to get it to work out. Till then get some sleep! Anyone else have any other ideas?

UPDATE: Bryan, thanks for the help! I figured out how to get the value I wanted using some of your formula and a lot of trial and error! =INDEX($O$2:$Q$2, MATCH(LARGE(O3:Q3,1),O3:Q3,0))