比如2，重复几次？共几个数字？我把数字改成133379，D1公式：=IF(FIND(MID(C1,1,1),C1)=1,MID(C1,1,1),"")&IF(FIND(MID(C1,2,1),C1)=2,MID(C1,2,1),"")&IF(FIND(MID(C1,3,1),C1)=3,MID(C1,3,1),"")&IF(FIND(MID(C1,4,1),C1)=4,MID(C1,4,1),"")&IF(FIND(MID(C1,5,1),C1)=5,MID(C1,5,1),"")&IF(FIND(MID(C1,6,1),C1)=6,MID(C1,6,1),"")&IF(FIND(MID(C1,7,1),C1)=7,MID(C1,7,1),"")&IF(FIND(MID(C1,8,1),C1)=8,MID(C1,8,1),"")&IF(FIND(MID(C1,9,1),C1)=9,MID(C1,9,1),"")
如下图示，
B2=IF(ISNUMBER(FIND(0,A2)),0,"")&SUBSTITUTE(SUMPRODUCT(ISNUMBER(FIND(ROW($1:$9),A2))*ROW($1:$9)*10^(10-ROW($1:$9))),0,"")——下拉填充。
图示
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024