Hey all!
I'm trying to make a VB macro to count the number of times a digit (0-9) occurs in a column. An example is the number 873338 would give 3=3, 7=1, 8=2 all else = 0. Normally i would just use a countif function and avoid VB altogether, but I cant think of a way to break apart the larger number and sum the digit occurrences. Any help would be greatly appreciated!
Attached is my attempt using countif and 3 pieces of sample data.
numberCounter.xlsm
Hello, try this in D6, then copy across
=SUMPRODUCT(LEN($A1:$A21)-LEN(SUBSTITUTE($A1:$A21,D5,"")))
Adjust the range.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Oh wow, that works amazingly, exactly what I needed. Thanks a lot. Could you explain how it works? Always trying to get better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks