Unique Digits in a CELL

[hrayani]

Dear Pgc01

this is the formula which you just posted to help me solve the Repeated Number of Digits in a cell

=IF(ISNUMBER(SEARCH(0&"*"&0,J14)),"0","")&SUBSTITUTE(SUMPRODUCT(ISNUMBER(SEARCH({1,2,3,4,5,6,7,8,9}&"*"&{1,2,3,4,5,6,7,8,9},J14))*{1,2,3,4,5,6,7,8,9}*10^{8,7,6,5,4,3,2,1,0}),0,"")

now the last cell issue is to show the unique digits in a cell

CELL A1 = 52556
Current Formula for Repeated Digits is showing a perfect result of 5

Now for the Unique Digits it should show 26

Awaiting reply,

Regards,

Humayun Rayani

 

[pgc01]

Hi again

Try:

=IF(LEN(A1)-LEN(SUBSTITUTE(A1,0,""))=1,"0","")&SUBSTITUTE(SUMPRODUCT((LEN(A1)-LEN(SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},""))=1)*{1,2,3,4,5,6,7,8,9}*10^{8,7,6,5,4,3,2,1,0}),0,"")

 

[hrayani]

Dear Pgc01

Thanks a lot..... Worked Perfect