Hello All,

My problem is I got this formula, which achieve the results I want
apart from one solution. The solution that I am looking for this
formula isn't happening. The equation is: -

=IF(OR(D15="",COUNTBLANK(D17:D20)0),"",IF(COUNTIF (D17:D20,D15)=4,D15,MIN(D17:D20)))

The solution that I am looking for if any number is selected out of
D17:D20 it should be display in D15, but the equation you must select
all 4 cells from D17:D20 for the min value to display in D15.

Anyone there that can help me?


many thanks

ims