Need help counting the unique digits ina list of numbers

**bigtraing** · 05-09-2013, 06:09 PM

Here is an example.
What forumula would I use?
1's 2's 3's 4's 5's 6's 7's 8's 9's 0's
List 6 2 2 2 2 0 0 0 0 1 Number of digits
1
2
3
4
5
10
12
13
14
15

**martindwilson** · 05-09-2013, 06:51 PM

well for a simple sample like that

**daddylonglegs** · 05-09-2013, 07:19 PM

If data is in A2:A10 and a specific digit in C1 then this formula will give a count of that digit

=SUMPRODUCT(LEN($A$2:$A$10)-LEN(SUBSTITUTE($A$2:$A$10,C1,"")))

**bigtraing** · 05-10-2013, 08:50 AM

Originally Posted by daddylonglegs

If data is in A2:A10 and a specific digit in C1 then this formula will give a count of that digit

=SUMPRODUCT(LEN($A$2:$A$10)-LEN(SUBSTITUTE($A$2:$A$10,C1,"")))

Awesome formula! Worked on my Test sample and the list of 48 numbers I needed digits for!

Cheers!