excel 里如何用函数把 相同名称的 多列数据 合并答:E4=C4&"("&D4&") "&B4&IFERROR("、"&VLOOKUP(A4,A5:E8,5,0),"")F4=IF(COUNTIF(A$4:A4,A4)=1,MAX(F$3:F3)+1,"")G4=IFERROR(INDEX(A:A,MATCH(ROW(A1),F:F,0)),"")H4=IF(G4="","",SUMIF(A:A,G4,B:B))I4=IFERROR(VLOOKUP(G4,$A$4:$E$8,5,0),""...