Hi

My code in my SHORT is:

=IF(ISERROR(INDEX('13DBC'!$A$1:$AE$50,SUMPRODUCT(S MALL(ROW('13DBC'!$10:$60)*('13DBC'!$C$10:$C$60<"" ),ROW()-9+COUNTA('13DBC'!$C$10:$C$60)-COUNTIF('13DBC'!$C$10:$C$60,"0"))),COLUMN()-1)),"",INDEX('13DBC'!$A$1:$AE$50,SUMPRODUCT(SMALL( ROW('13DBC'!$10:$60)*('13DBC'!$C$10:$C$60<""),ROW ()-9+COUNTA('13DBC'!$C$10:$C$60)-COUNTIF('13DBC'!$C$10:$C$60,"0"))),COLUMN()-1))

and my OVER is:

=IF(ISERROR(INDEX('13DBC'!$A$1:$AE$50,SUMPRODUCT(S MALL(ROW('13DBC'!$10:$60)*('13DBC'!$D$10:$D$60<"" ),ROW()-9+COUNTA('13DBC'!$D$10:$D$60)-COUNTIF('13DBC'!$D$10:$D$60,"0"))),COLUMN()-1)),"",INDEX('13DBC'!$A$1:$AE$50,SUMPRODUCT(SMALL( ROW('13DBC'!$10:$60)*('13DBC'!$D$10:$D$60<""),ROW ()-9+COUNTA('13DBC'!$D$10:$D$60)-COUNTIF('13DBC'!$D$10:$D$60,"0"))),COLUMN()-1))

for some reason, it ignores the last short and over barcodes in 13DBC,
which is:

SHORT:
6001009002600 12.000 units (column C52)

OVER:
2906818000004 2.000 units (column C60)

It does not give the same problem in my 8DBC's please help

My file is a little big, and I cant make it any smaller.
here it is http://www.epping.co.za/stockproblem.zip

you can take the password off as follows: ToolsProtectionunprotect.
there is no password.

Thanks.
Sonar


--
sonar
------------------------------------------------------------------------
sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=470611