How do I pull the column header next to a Max formula?

M

mconway

I have created a column on the righ of a chart that pulls the max number from
each row. Now I would like to add acolumn next to with the column header of
that row...any suggestions?
 
B

Biff

Hi!

B1:F1 are your column headers
B2:F2 = some numbers
G2 = =MAX(B2:F2)
H2 = formula for corresponding column header

=INDEX(B$1:F$1,MATCH(G2,B2:F2,0))

Copy down as needed.

Biff
 
B

Biff

P.S.

If there are duplicate MAX values the formula will return the header that
corresponds to the first instance of MAX.

Biff
 
Top