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...
excel两行数据合并成一行,重复数据合并,不同数据合并到同一单元格且保留...答:需要加辅助列(黄色区域)G2=IF(IF(ISERROR(VLOOKUP(A2,$A3:$G9,COLUMN(B1),)),"",VLOOKUP(A2,$A3:$G9,COLUMN(B1),))=$B2,B2,B2&IF(ISERROR(VLOOKUP(A2,$A3:$G9,7,)),"",","&VLOOKUP(A2,$A3:$G9,7,)))向下向右复制 M2=INDEX(A:A,MIN(IF(COUNTIF(M$1:M1,$A$2:$A...