software

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_IDCLASS1CLASS2CLASS3
A2510
B12104
C5115
D2612
E1239So in this case, when the formula is run it will return quot;CLASS3quot; for Row A
and quot;CLASS1quot; for Row B and so on..

Thanks for you help


Assuming that your Column Titles are in Row1 and that Data begins Row2
=INDEX(A11,0,MATCH(MAX(A22),A22,0))--
kraljb
------------------------------------------------------------------------
kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
View this thread: www.excelforum.com/showthread...hreadid=523634Thanks, that worked perfectly

quot;kraljbquot; wrote:

gt;
gt; Assuming that your Column Titles are in Row1 and that Data begins Row2
gt; =INDEX(A11,0,MATCH(MAX(A22),A22,0))
gt;
gt;
gt; --
gt; kraljb
gt; ------------------------------------------------------------------------
gt; kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
gt; View this thread: www.excelforum.com/showthread...hreadid=523634
gt;
gt;