Simone
源数据在Sheet1，“名称单位单价”顺序为A、B、D列，第1行是表头，数据从第2行起：在Sheet2的A1输入=INDEX(Sheet1!A:A,SMALL(IF(MATCH(Sheet1!$A$1:$A$100&Sheet1!$B$1:$B$100&Sheet1!$C$1:$C$100,Sheet1!$A$1:$A$100&Sheet1!$B$1:$B$100&Sheet1!$C$1:$C$100,)=ROW($1:$100),ROW($1:$100),4^8),ROW(1:1)))&""数组公式，毕雹输入判此后先不要回车，按Ctrl+Shift+Enter结束计算，再向右和向下填充。在Sheet2的C2（数量）输入=SUMPRODUCT((Sheet1!A$2:A$100=A2)*(Sheet1!B$2:B$100=B2)*(Sheet1!D$2:D$100=D2)*Sheet1!C$2:C$100)回车并向下填充。（因方便你操手冲帆作，原已输入公式的，替换掉）在Sheet2的E2（金额）输入=SUMPRODUCT((Sheet1!A$2:A$100=A2)*(Sheet1!B$2:B$100=B2)*(Sheet1!D$2:D$100=D2)*Sheet1!E$2:E$100)回车并向下填充。
