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

[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?

[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

"mconway" <mconway@discussions.microsoft.com> wrote in message
news:A46611C4-5257-4E43-9B62-357552E7C56C@microsoft.com...
>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?

[Biff]

P.S.

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

Biff

"Biff" <biffinpitt@comcast.net> wrote in message
news:%23ij9EZ%23cGHA.5048@TK2MSFTNGP03.phx.gbl...
> 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" <mconway@discussions.microsoft.com> wrote in message
> news:A46611C4-5257-4E43-9B62-357552E7C56C@microsoft.com...
>>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?
>
>