Dmitriy Kritskiy
asked on
Looking up min and second lowest values based on criteria in a range of non-adjacent cells [Excel]
Hello,
I need help writing two formulas. Let's say there is a set of nonadjacent cells in Column B that have numeric values. Some values can be zero. I want to be able to find the minimum value in Column B that's not zero based only on cells that meet a certain criteria in column A. Based on the attached file: find the min value that's not zero for all alpha. Second formula: find the 2nd lowest value for alphas. Is this possible to do?
sample.xlsx
I need help writing two formulas. Let's say there is a set of nonadjacent cells in Column B that have numeric values. Some values can be zero. I want to be able to find the minimum value in Column B that's not zero based only on cells that meet a certain criteria in column A. Based on the attached file: find the min value that's not zero for all alpha. Second formula: find the 2nd lowest value for alphas. Is this possible to do?
sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome. Glad we could help.
ASKER