+ Reply to Thread
Results 1 to 4 of 4

Minimum based on condition problem (and F9 vs cell evaluation issue)

  1. #1
    Registered User
    Join Date
    09-04-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Minimum based on condition problem (and F9 vs cell evaluation issue)

    Hello,

    I am having some trouble with a formula to find the minimum of a data set based on a condition. I don't know if my problem is with my formulas, but I am seeing an issue where highlighting the whole formula in the formula bar and using F9 is not yielding the same result as the cell yields on its own. Has anyone ever seen this?

    If anyone can help with the problem at hand, that would be appreciated too.

    I need to find the minimum of a subset of a data set, where the subset is defined by the condition based on another cell. See below.

    a 1
    b 1
    a 2
    a 3
    b 3
    b 5
    a 4
    b 8

    I need to find the minimum value in column B for which column A is equal to b (for example). I attempted multiplying arrays, but didn't have any luck and I'm stumped because of the issue with the F9 evaluation vs true cell evaluation.

    I know its vague so I'm attaching an example that will maybe help explain. Try evaluating the cell in the formula bar with F9 - its not what the cell shows!

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Minimum based on condition problem (and F9 vs cell evaluation issue)

    Hi ctosborne89

    How about this in D5 & CSE, copy down!
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-04-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Minimum based on condition problem (and F9 vs cell evaluation issue)

    I don't know why I didn't just ask here a long time ago. Thanks so much.

  4. #4
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Minimum based on condition problem (and F9 vs cell evaluation issue)

    No problem ctosborne89 , thank you for the feed back.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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