Excel如何按条件将多个单元格合并到一个单元格答:D2=A2&SUMPRODUCT(($A$2:$A$15=A2)*($C$2:$C$15>C2))+COUNTIFS(A$2:A2,A2,C$2:C2,C2)E2=IF(COUNTIF(A$2:A2,A2)>5,"",INDEX(B:B,MATCH(A2&COUNTIF(A$2:A2,A2),D:D,0)))F2=IF(E2="","",CHAR(10)&E2&IFERROR(VLOOKUP(A2,A3:F15,6,0),""))B22=SUBSTITUTE(...