Product | Cr1 | Cr2 |
A | 0.9619 | 2.54 |
B | 0.8791 | 1190.17 |
C | 0.8386 | 1567.58 |
D | 0.7724 | 1.36 |
E | 0.7508 | 1.53 |
F | 0.7508 | 18.06 |
G | 0.7485 | 1659.38 |
H | 0.7485 | 1649.66 |
I | 0.7485 | 1661.76 |
J | 0.7153 | 1617.04 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
My Excel has 3 columns, these basically has 2 Criterions -
Cr 2 : Has to be minimum possible with threshold as 2 (i.e. cannot be less than 2)
Cr 1 : Has to be maximum amongst the minimum possible values of Cr 2.
For e.g. Above, select minimum of Cr 2 > D & E and then select Max amongst D & E - which is E
So the result is E
Have to do the same repeatedly so want some automation solution (formula etc) related to the same.