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