Hello,
I need a simple MIN formula with 2 criteria. Below Is the table
<tbody>
</tbody>
I would like the formula to lookup criteria under column A and give me the min value only for systemic parts. example component A, SYSTEMATIC MIN value is 10
I need a simple MIN formula with 2 criteria. Below Is the table
component | description | qty |
a | systematic | 10 |
d | non-systematic | 62 |
c | systematic | 84 |
b | systematic | 56 |
d | systematic | 3 |
b | non-systematic | 1 |
a | non-systematic | 9 |
c | systematic | 84 |
b | systematic | 25 |
f | non-systematic | 9 |
<tbody>
</tbody>
I would like the formula to lookup criteria under column A and give me the min value only for systemic parts. example component A, SYSTEMATIC MIN value is 10
Last edited: