|
在sheet3的a1写公式:=IF(ROW()<=COUNTA(Sheet1!A:A),Sheet1!A1,INDEX(Sheet2!A:A,SMALL(IF(COUNTIF(Sheet1!A$1:A$100,Sheet2!A$1:A$100),4^8,ROW($1:$100)),ROW()-COUNTA(Sheet1!A:A)))&"")这是数组公式,要按ctrl+shift+enter三键结束下拉填充在SHEET3的B1写公式:=SUMIF(Sheet1!A:A,A1,Sheet1!B:B)-SUMI... |
