Select maximum value and associated column name

Question

Hello,

I would like to reformat/ query a table like the one below to select not only the maximum value from each row, but also the column name it is associated with.  I'm not very familiar with SQL or macros or scripting.  Any advice for something relatively easy?  I'd pretty much like the resulting table to look like the one below if possible.

Thanks,

Aly

RecordID (Column A)	Class1 (Column B)	Class2 (Column C)	max value per row	?CLASS (column name??)
1	50	100	[=max(B2:C2)] = 100	= Class2
2	200	50	[=max(B3:C3)] = 200	= Class1

Answer 1

Hi,

Put this in E2 and drag down.

=INDEX($B$1:$C$1,MATCH(MAX(B2:C2),B2:C2,0))

Answer 2

Awesome.  Worked perfectly.

Thanks!