=UNIQUE(A2:A6)
▼数组公式，三键录入，下拉填充 =IFERROR(INDEX($A$2:$A$18,MATCH(,COUNTIF($D$1:D1,$A$2:$A$6),)),"")
=UNIQUE(TOCOL(C1:E6))
=CONCAT(UNIQUE(MID(A2,ROW($1:$16),1)))
=CONCAT(REGEXEXTRACT(A2,"(.)(?!.*\1)",1))
一键速达
=UNIQUE(A2:A6)
▼数组公式，三键录入，下拉填充 =IFERROR(INDEX($A$2:$A$18,MATCH(,COUNTIF($D$1:D1,$A$2:$A$6),)),"")
=UNIQUE(TOCOL(C1:E6))
=CONCAT(UNIQUE(MID(A2,ROW($1:$16),1)))
=CONCAT(REGEXEXTRACT(A2,"(.)(?!.*\1)",1))
一键速达
