View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.