求大神,EXCEL怎么满足条件1是,得出的ABCD变成一个单元格内的A,B,C...答:添加四列辅助列,分别输入以下公式,然后向下填充公式 =IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1,B2,"")=D2&IF(COUNTIF(A3:A$12,A2)>0," "&VLOOKUP(A2,A3:E$12,5,0),"")=IF(COUNTIFS(A$2:A2,A2,C$2:C2,C2)=1,C2,"")=F2&IF(COUNTIF(A3:A$12,A2)>0," "&VLOOKUP(...