...想要把相同字段合并成一条记录,保留不同字段内容。答:假定现合并表的三列是即定写好了的,如:32、五一、表1,那么在D2输入=IFERROR(sumifs(原始表!$D$2:$D$1000,原始表!$A$2:$A$1000,$A2,原始表!$B$2:$B$1000,$B2,原始表!$C$2:$C$1000,$C2),0),在F2输入=IFERROR(sumifs(原始表!$D$2:$D$1000,原始表!$A$2:$A$1000,$...
Excel表格怎么把订单号相同的两行单元格,合并成一行且保留上下两...答:A11=INDEX(A:A,MIN(IF(COUNTIF($A$10:$A10,$A$1:$A$7),4^8,ROW($A$1:$A$7)))&""向下复制 B11=INDEX(B:B,SMALL(IF($A$2:$A$7=$A11,ROW($A$2:$A$7),4^8),1))&IF(INDEX(B:B,SMALL(IF($A$2:$A$7=$A11,ROW($A$2:$A$7),4^8),1))=INDEX(B:B,SMALL...