Cells B1 thru M1 are labeled with column headings that are the months of the year (i.e. jan-03, feb-03, mar-03, etc.)
Cells B2 thru M2 include a monthly stat for each month.
Cell A1 needs to display the MONTH of the year (i.e. jan-03, feb-03, mar-03, etc.) that has the highest stat, but not the highest STAT itself as "MAX=" would do.
How can I accomplish displaying just the month, by name?

Hi

Following formula will do the trick:

=INDEX(D1:H1,MATCH(MAX(D2:H2),D2:H2,0))

You need to adjust it to fit Your needs.

Kind regards,
Dennis

Thank you for the prompt reply!

Something is wrong: I'm getting "#N/A"

The reference cells are not adjacent so I named each one and enclosed the string in parens.

Here's what I'm using:

=INDEX((Feb_04,Jan_04,Dec_03,Nov_03,Oct_03,Sep_03, Aug_03,Jul_03,Jun_03,May_03,Apr_03,Mar_03),MATCH(M AX((DD3,DM3,U3,AD3,AM3,AV3,BE3,BN3,BW3,CF3,CO3,CX3 )),(DD3,DM3,U3,AD3,AM3,AV3,BE3,BN3,BW3,CF3,CO3,CX3 ),0))

Perhaps this can not be done if the reference cells are not within a continuous range?

Hi,

It require another approach. Let me see if I can come up with something or if a user-define function could be apply.

Kind regards,
Dennis