Find Largest and Return Column Name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom321 - 17 Mar 2006 17:48 GMT

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

Reply to this Message

kraljb - 17 Mar 2006 17:56 GMT

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

Reply to this Message

Tom321 - 17 Mar 2006 18:09 GMT

Thanks, that worked perfectly

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

Reply to this Message