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

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?

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

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

"mconway" wrote in message
...
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?

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

P.S.

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

Biff

"Biff" wrote in message
...
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

"mconway" wrote in message
...
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?