Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: Auto display highest month

    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?

  2. #2
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    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
    Kind regards,
    Dennis

  3. #3
    Join Date
    Feb 2004
    Posts
    5

    Auto display highest month

    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?

  4. #4
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    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
    Kind regards,
    Dennis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •