MAX Function and Corresponding Column

I have a spreadsheet with 60 columns and 1500 rows of data. For each row I need to idenitify the column with the maximum value (I used the MAX function and it worked fine). My problem is, I need to identify the column that contains the maximum value. For example: MAX(g2:bv2) max value is 5.7 belonging to column L2. Each column has a distinct column heading. Any suggestions?

Hi,

try this:

=INDEX($G$1:$BV$1,1,MATCH(MAX(G2:BV2),G2:BV2,0))

HTH

Art

Hey Art.

That worked perfectly. How about this. With that same data group is theere a way to identify the next 2 highest values after the max value aand their corresponding column heading?

Thank you very much.

L-

You have to use large function for this

=INDEX($A$1:$C$1,1,MATCH(LARGE(A2:C2,2),A2:C2,0))