EXCEL一个单元格里的一组数据，相同的数字怎么只保留一个

Question

如题所述

Answer 1

公式如下：=SUBSTITUTE(SUMPRODUCT(ISNUMBER(FIND(ROW($1:$9),E3))*ROW($1:$9)*10^ROW($1:$9)),0,)&IF(ISERROR(FIND(0,E3)),"",0)

Answer 2

f3=SUBSTITUTE(SUM(IF(FIND(MID(E3,ROW(INDIRECT("1:"&LEN(E3))),1),E3)=ROW(INDIRECT("1:"&LEN(E3))),MID(E3,ROW(INDIRECT("1:"&LEN(E3))),1)*10^(LEN(E3)-ROW(INDIRECT("1:"&LEN(E3)))))),0,"")&IF(COUNT(FIND(0,E3)),0,"")，数组公式，同时按ctrl+shift+回车结束，下拉本回答被网友采纳

Answer 3

需要的话留QQ