Condition Problem

[M_jordan]

sample.jpg
sample.xlsx

Gentlemen,

I need your kind support, please refer to the attached excel sample file (a snapshot also attached) I've made. In the provided example I have 5 cases with 2 properties for each case, and I need to find the best case according to the following conditions : (Property2) should falls between or equals to (3 and 7) AND (property1) should be at MAX

In the sample the result is (Case 5), can you please provide the formula (or may be Macro) to do that ?


Thanks in advance,
Mustafa

[boopathiraja]

Try with the below array formula

Please Login or Register  to view this content.

[boopathiraja]

If you want the result as case 5
Try with the below array formula

Please Login or Register  to view this content.

Note Array formula's need to be entered with ctrl+shift+enter (not just enter)

[M_jordan]

Perfect, thank you very much