Counting Digits formula !!

[serge]

Hi All,

I need help to count digits from 5 numbers, 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. Serge.

 

[sanrv1f]

try this

Excel Workbook
	A	B
1	05
2	07
3	12
4	29
5	45
6	30	8
Sheet1

Excel 2003

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[serge]

Thank you sanrv1f,

It work fine the way you did it, but I tried to do it in row and it didn't work why ? I did change A1: A6 to A1:F1 with Ctrl+Shift+Enter

A1,B1,C1,D1,E1,F1. and it give me : 1 as result, using the same number.

Thank you.

 

[sanrv1f]

for columns you need to use

{1;2;3;4;5;6;7;8;9;0}

 

[mvptomlinson]

..

 

[serge]

No this one is a different formula, One what to count High and Low and this one is to count how many digits.

Thanks again mvptomlinson for your help.

 

[serge]

sanrv1f,

I have a small problem I did the change like you show me and with some combinations I get the good answer and for others not !!!

For example the combination : 02,09,12,18,21

With your formula :

=SUM(--(FREQUENCY(IF(ISNUMBER(SEARCH({1;2;3;4;5;6;7;8;9;0},A1:A1:E1)),{1;2;3;4;5;6;7;8;9;0}),{0;1;2;3;4;5;6;7;8;9})>0))

with Ctrl+Shift+Enter should give me : 5 but I get a : 4 ??

Unless I'm doing something wrong ?

 

[serge]

Any help would be really appreciated, Thanks.

=SUM(--(FREQUENCY(IF(ISNUMBER(SEARCH({1;2;3;4;5;6;7;8;9;0},A1:E1)),{1;2;3;4;5;6;7;8;9;0}),{0;1;2;3;4;5;6;7;8;9})>0))

 

[sanrv1f]

I got 5 for the same formula

Excel Workbook
	A	B	C	D	E	F
1	02	09	12	18	21	5
Sheet1

Excel 2003

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[serge]

Thank you for responding sanrv1f,

But I think the problem with me is that the formula don't count the leading "0" on my side is because they might not be formated the right way ?

Can you tell me how to do it right ?

Thank you.