Excel如何按条件将多个单元格合并到一个单元格答: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(VLOOKUP(A19,$A$2:$F$15,6,0),CHAR(10),"",1)向下复制 注意:1、产品123可以用数据-筛选-高级...