Digits Count

[serge]

Hello everyone,

I need help please, with a formula that will count the digits used in a series of 5 numbers that I formated/Number/Custom/00.in 5 different cell, without counting Duplicate.

A1 : 05
B1 : 07
C1 : 12
D1 : 29
E1 : 30

In G1 the formula should give me : 7 as result.

Thank you in advance. Serge.

 

[barry houdini]

Here's one way....

=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},TEXT(SUMPRODUCT(A1:E1,10^{0,2,4,6,8}),"0000000000")))

 

[serge]

Thank you barry,

Sorry I stepped out for a while, but it Worked like a charm, Thank you so much!! Your a genius!!

Serge.

 

[pgc01]

Hi

For ranges with different numbers of cells, for ex. A1:J1, try also:

=SUM(0+(FREQUENCY(MOD(INT(A1:J1/{1;10}),10),{0,1,2,3,4,5,6,7,8,9})>0))

 

[barry houdini]

Nice formula Pedro

 

[serge]

Thank you pgc01, this formula work fine also.
Serge.