Is there a function in MS Excel that counts the occurrences of a digit? Len counts the number of characters in a cell but that's different.
using Len on 123456789 gives 9
but I need something like
Digit Count
1 1
2 1
3 1
4 1
5 1
6 1
7 1
8 1
9 1
Is there a function in MS Excel that counts the occurrences of a digit? Len counts the number of characters in a cell but that's different.
using Len on 123456789 gives 9
but I need something like
Digit Count
1 1
2 1
3 1
4 1
5 1
6 1
7 1
8 1
9 1
A B C 1 Digits Entire Count Incremental Count 2 1 1 1 3 2 2 1 4 3 1 1 5 4 1 1 6 5 2 1 7 6 1 1 8 7 1 1 9 8 1 1 10 9 1 1 11 2 2 2 12 5 2 2
B C 2 =COUNTIF(A:A,A2) =COUNTIF($A$2:A2,A2)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Let say your given number is in A11
Criteria digit starts from A1
In B1:
=LEN($A$11)-LEN(SUBSTITUTE($A$11,A1,""))
Drag down
Quang PT
I may have accidentally left out some details. This the setup and I want to count all digits shown.
Book01.xlsx
Your requirement in Post 1 is not match with the file attached in Post 4
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
With a pivot table.
I made it for count and sum of the data.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Then what is your requirement?
show us a small excel file, without confidential information.
please also add the expected result in your file.
Here's a screenshot
Screenshot.jpg
Last edited by Volle12; 10-29-2015 at 05:20 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
This place in E2 to count number(in D2) exist in A2:A20
=SUMPRODUCT(LEN($A$2:$A$20)-LEN(SUBSTITUTE($A$2:$A$20,D2,"")))
Drag down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks