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.
Bookmarks