+ Reply to Thread
Results 1 to 5 of 5

Formula for Next Minimum Value Above a Specified Value

  1. #1
    Registered User
    Join Date
    07-26-2006
    MS-Off Ver
    Office 365
    Posts
    97

    Formula for Next Minimum Value Above a Specified Value

    I am trying to write a formula that will return the next minimum value that is above a specific number in another cell.

    I have tried MINIFS but it does not like the “>” operator when it refers to another cell. Any thoughts on how to get around this? Check out the attachment for a better example.

    Any feedback helps. Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Formula for Next Minimum Value Above a Specified Value

    This would probably take an array formula, but I don't understand the requirement. Cell B3 is blank, Cell B4 has the number 4 and Cell B5 is also blank.

    Also I could not "reverse engineer" the results. How did you come by 4, 9 and 19?
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    07-26-2006
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Formula for Next Minimum Value Above a Specified Value

    dflak, thank you for a quick response.
    I apologize for the lack of clarity. I did additional formatting after I typed in my request. In cell B7, I am looking for a formula that returns the number "4" (from the value in B18). The idea would be to copy that formula down in B8, which will then pick up the "9" identified in B23.
    My apologies for my lack of clarity.
    I did try an array but must have the incorrect syntax since I couldn't get it to work.

    Thank you again.

  4. #4
    Spammer
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365
    Posts
    302

    Re: Formula for Next Minimum Value Above a Specified Value

    Hi, Cardan! (and dflak)

    You can use this formula:
    [B6] : =MINIFS(B$15:B$83,C$15:C$83,C$4,D$15:D$83,D$4,$E$15:$E$83,E$4,B$15:B$83,">"&0+B5)

    And drag it down. Blessings!

  5. #5
    Registered User
    Join Date
    07-26-2006
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Formula for Next Minimum Value Above a Specified Value

    This works! The syntax at the end of the formula was my missing link!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 04-17-2013, 03:53 PM
  2. [SOLVED] Minimum but not less than formula
    By Khaldon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2012, 08:32 AM
  3. Formula with a minimum value
    By gazfraz in forum Excel General
    Replies: 4
    Last Post: 09-02-2010, 07:36 AM
  4. Find minimum SUM if no minimum number in row
    By zbor in forum Excel General
    Replies: 9
    Last Post: 12-25-2009, 05:04 AM
  5. Minimum non-zero within array formula
    By Cheeky Charlie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-31-2008, 12:16 PM
  6. Replies: 4
    Last Post: 05-09-2007, 11:46 AM
  7. [SOLVED] How to lookup the minimum, 2nd minimum and 3rd minimum.........
    By Mark McDonough in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-15-2006, 04:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1