貨品與箱子長寬高須完全符合 (12808)

J3:P16{=IF(RIGHT(MIN(IF(MMULT(N(RIGHT(SMALL(TRIM(MID(SUBSTITUTE($G$3:$G$9,"x",REPT(" ",59)),{1,2,3}*59-58,59))+ROW(1:7)/1%%,{0,1,2}+ROW($1:$7)*3-2),4)-RIGHT(SMALL(TRIM(MID(SUBSTITUTE($B3,"x",REPT(" ",59)),{1,2,3}*59-58,59))*1,{1,2,3}),4)>0),{1;1;1})=3,MMULT(RIGHT(SMALL(TRIM(MID(SUBSTITUTE($G$3:$G$9,"x",REPT(" ",59)),{1,2,3}*59-58,59))+ROW(1:7)/1%%,{0,1,2}+ROW($1:$7)*3-2),4)-RIGHT(SMALL(TRIM(MID(SUBSTITUTE($B3,"x",REPT(" ",59)),{1,2,3}*59-58,59))*1,{1,2,3}),4),{1;1;1})/1%+ROW($1:$7))),2)-COLUMN(A1)=0,$D3,"")