Posted to microsoft.public.excel.worksheet.functions
|
|
insert column header in cell below result of max FUNCTION
Try this:
...........A..........B..........C..........D.....
1......Wk1....Wk2.....Wk3.....Wk4
2.......22.........17.........44........30
=INDEX(A1:D1,MATCH(MAX(A2:D2),A2:D2,0))
Result = Wk3
--
Biff
Microsoft Excel MVP
"mark s" <mark wrote in message
...
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.
|