excel中如何用公式把多列数据合并成1列,重复的数据只显示一次:答:用if嵌套就可以了 1、在E列中输入:=IF(ROW()<COUNTA(A:A)+1,INDEX(A:A,ROW(),1),IF(ROW()<COUNTA(A:A)+COUNTA(B:B),INDEX(B:B,ROW()-COUNTA(A:A)+1,1),INDEX(B:B,ROW()-COUNTA(A:A)-COUNTA(B:B)+2,1)))2、然后用“筛选”-“去除重复值”,复制到D列即可,OK ...
EXCEL问题,不规则多列如何变成一列答:=OFFSET(A$1,MAX(IF(SMALL(--IF(A$1:G$20<>"",COLUMN(A1:G1)&TEXT(ROW($1:$20),"000"),9^9),ROW(A1))=--(COLUMN(A1:G1)&TEXT(ROW($1:$20),"000")),ROW($1:$20)))-1,MAX(IF(SMALL(--IF(A$1:G$20<>"",COLUMN(A1:G1)&TEXT(ROW($1:$20),"000"),9^9)...