EXCEL中ABCD列内容相同,只有E列内容不同,如何合并到一行。如图答:=INDEX(A:A,SMALL(IF((MATCH($C$1:$C$999&"",""&$C$1:$C$999,)=ROW($C$1:$C$999))*($C$1:$C$999<>""),ROW($C$1:$C$999),4^8),ROW()))&""---K1数组公式:=INDEX($E:$E,SMALL(IF(($C$1:$C$999&"")=$I1,ROW($C$1:$C$999),4^8),COLUMN(E1)-4)...
求大神,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(...
excel中,考试题有ABCD四个选项,怎么让正确答案单独显示成一列,比如正...答:J2单元格写入公式 =IF(D2="","",INDEX(E2:H2,MATCH(D2,{"A","B","C","D"},)))或 =IF(D2="","",INDEX(E2:H2,FIND(D2,"ABCD")))下拉复制公式