Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: index match min & max (excel 2003)

    Welcome to Woody's Lounge.

    Do you mean that you want to enter values in K2 and L2, and have M2 and N2 filled in automatically?
    Can you explain how the values in M2 and N2 are derived? They are not equal to min(sdep1) and max(sdep2) as the coilumn headings suggest.

  2. #2
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    index match min & max (excel 2003)

    say, i have a data as per the attached file and i want to extract from it the data in the format outlined in columns K,L,M,N in the same file.
    thanks in advance.

    correction,
    the data in column(N) is -6969
    TIA
    dubdub

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: index match min & max (excel 2003)

    yes, and the data in M & N ware simply the minimum and the maximum of no(5) and cat(hello1) in the data.
    TIA
    dubdub

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: index match min & max (excel 2003)

    The following formulas are array formulas, i.e. you must confirm them with Ctrl+Shift+Enter instead of just Enter. When you do this, you will see { } around the formula in the formula bar; you must not type those yourself, they are only an indication that the formula is an array formula.

    In M2: =MIN(IF((B2:B65536=K2)*(C2:C65536=L2),G2:G65536))
    In N2: =MAX(IF((B2:B65536=K2)*(C2:C65536=L2),I2:I65536))

  5. #5
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: index match min & max (excel 2003)

    thanks HANS.
    TIA
    dubdub

Posting Permissions

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