I would like to find Min and Max of Quantity (Column 2) based on Type (coloumn 1), is it possible to have this done?
I have tried this but the result was unexpected Similar question
6 Answers
@JamesL's solution always resulted in zero for me when attempting
=MIN(IF(A2:A13="A",1,0)*(B2:B13))
If I set it up with an arbitrarily large number for the false result, then it worked
=MIN(IF(A2:A13="A",1,99999)*(B2:B13))
However, @GSerg's elegant solution also works for the min:
=MIN(IF(A:A="A",B:B))
Related