Find Largest and Return Column Name
 

I am comparing 3 columns and trying to find the maximum value of the columns.
But instead of just displaying the maximum value I would like it to show
which column the value is from.

OBS_ID CLASS1 CLASS2 CLASS3
A 2 5 10
B 12 10 4
C 5 1 15
D 2 6 12
E 1 23 9


So in this case, when the formula is run it will return "CLASS3" for Row A
and "CLASS1" for Row B and so on..

Thanks for you help

Find Largest and Return Column Name
 

Assuming that your Column Titles are in Row1 and that Data begins Row2
=INDEX(A1:D1,0,MATCH(MAX(A2:D2),A2:D2,0))


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=523634

Find Largest and Return Column Name
 

Thanks, that worked perfectly

"kraljb" wrote:


Assuming that your Column Titles are in Row1 and that Data begins Row2
=INDEX(A1:D1,0,MATCH(MAX(A2:D2),A2:D2,0))


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=523634