Excel去重复数的2例公式

1、=SUBSTITUTE(SUMPRODUCT(ISNUMBER(FIND(ROW($1:$10),J3))*ROW($1:$10)*10^ROW($1:$10)),0,)&IF(ISERROR(FIND(0,J3)),"",0)

2、=LEFT(TEXT(SUM((0&MID(J2,LARGE(FIND(ROW($1:$10)-1,J2&5^19),ROW($1:$10)),1))*10^ROW($1:$10)),REPT(0,11)),COUNT(FIND(ROW($1:$10)-1,J2)))

四码合并   除重
3467234845783789  34672859
4578345956890489 45783960
5689045606790159 56890471
0126017806791567 01267895
(0)

相关推荐