本帖最后由 baksy 于 2014-6-27 10:40 编辑
A6=IF(ROW()>COUNTIF(出货数据!$A$2:$A$8,$H$2)+5,"",INDEX(出货数据!B$1:B$8,SMALL(IF(出货数据!$A$2:$A$8=$H$2,ROW($B$2:$B$8)),ROW(A1))))
B6=IF(ROW()>COUNTIF(出货数据!$A$2:$A$8,$H$2)+5,"",INDEX(出货数据!G$1:G$8,SMALL(IF(出货数据!$A$2:$A$8=$H$2,ROW($B$2:$B$8)),ROW(B1))))
C6=IF(ROW()>COUNTIF(出货数据!$A$2:$A$8,$H$2)+5,"",INDEX(出货数据!H$1:H$8,SMALL(IF(出货数据!$A$2:$A$8=$H$2,ROW($B$2:$B$8)),ROW(C1))))
E6=IF(ROW()>COUNTIF(出货数据!$A$2:$A$8,$H$2)+5,"",INDEX(出货数据!I$1:I$8,SMALL(IF(出货数据!$A$2:$A$8=$H$2,ROW($B$2:$B$8)),ROW(E1))))
F6=IF(ROW()>COUNTIF(出货数据!$A$2:$A$8,$H$2)+5,"",INDEX(出货数据!J$1:J$8,SMALL(IF(出货数据!$A$2:$A$8=$H$2,ROW($B$2:$B$8)),ROW(F1))))
H6=IF(ROW()>COUNTIF(出货数据!$A$2:$A$8,$H$2)+5,"",INDEX(出货数据!K$1:K$8,SMALL(IF(出货数据!$A$2:$A$8=$H$2,ROW($B$2:$B$8)),ROW(H1))))
I6=H6*E6
除I6公式以外,全部是三键回车( 公式复制后,点一下公式编辑栏的任意位置,先按住 shift、ctrl 两个键,然后敲enter键。)
下拉。