View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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?