insert column header in cell below result of max FUNCTION

[mark s]

I am using the MAX function to select a cell value, I would like to print
the column header of the column that the cell value was selected from in the
cell below the results of the max function.

 

[Max]

One way to extract it directly ..

Assume col headers in B11, with values in row2 down
Put in say A2, copy down:
=INDEX(B$1$1,MATCH(MAX(B22),B22,0))
to return the required col header

If there are ties in the max, the leftmost header will be returned
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik

 

[T. Valko]

Try this:

...........A..........B..........C..........D.....
1......Wk1....Wk2.....Wk3.....Wk4
2.......22.........17.........44........30

=INDEX(A11,MATCH(MAX(A22),A22,0))

Result = Wk3