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)