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?

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" <[email protected]> wrote in message
news:[email protected]...
>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?

P.S.

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

Biff

"Biff" <[email protected]> wrote in message
news:%23ij9EZ%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>>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?
>
>