Min AND Small function

I'm trying to find the MIN value in range and if MIN value is 0 then find the 2nd smallest value.

A3 = Date
'DB05'!U2:U501 = Date serial nr
AE3 = Date serial nr
'DB05'!F2:501 = Quantity

=IF(A3>0;IF(MIN(IF('DB05'!$U$2:$U$501=AE3;'DB05'!$F$2:$F$501))>1;MIN(IF('DB05'!$U$2:$U$501=AE3;'DB05'!$F$2:$F$501));SMALL(IF('DB05'!$U$2:$U$501=AE3;'DB05'!$D$2:$F$501);2));"")

The formula works when the Quantity in range are:
500
600
1000
5000

But not when the Quantity in range are :
500
600
1000
Blank or 0

then the formula give a value of 1.

What have I done wrong ?

Try the following...

=IF(A3>0,MIN(IF(('DB05'!$F$2:$F$501>0)*('DB05'!$U$2:$U$501=AE3),'DB05'!$F$2:$F$501)),"")

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Originally Posted by yakumo

I'm trying to find the MIN value in range and if MIN value is 0 then find the 2nd smallest value.

A3 = Date
'DB05'!U2:U501 = Date serial nr
AE3 = Date serial nr
'DB05'!F2:501 = Quantity

=IF(A3>0;IF(MIN(IF('DB05'!$U$2:$U$501=AE3;'DB05'!$F$2:$F$501))>1;MIN(IF('DB05'!$U$2:$U$501=AE3;'DB05'!$F$2:$F$501));SMALL(IF('DB05'!$U$2:$U$501=AE3;'DB05'!$D$2:$F$501);2));"")

The formula works when the Quantity in range are:
500
600
1000
5000

But not when the Quantity in range are :
500
600
1000
Blank or 0

then the formula give a value of 1.

What have I done wrong ?