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),""...
一个Excel涉及到VBA的问题!答:正确的语句:Sub 关键信息() ActiveSheet.Range("D:D,G:G,H:H,J:J,O:O,P:P,U:U,V:V,W:W,Z:Z,AA:AA,AB:AB,AC:AC,AD:AD,AE:AE").EntireColumn.Hidden = TrueEnd Sub