identify the quantity of each string
https://www.excelforum.com/attachmen...1&d=1526034798
identify the quantity of each string
https://www.excelforum.com/attachmen...1&d=1526034798
Hello Jorel,
What is the meaning of the colored numbers (AE4:BP4)?
Why is 2 under 7.7 and all other numbers are zero?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
What is the meaning of the colored numbers (AE4: BP4)? are all possibilities of strings
* within 01 to 42
Why is 2 under 7.7 and all other numbers are zero?
two means twice present in the draw line
* zero means the string of digits is not present
* objective = is to identify strings of digits
* (1) (1.1) ..... (1,1,1,1)
If I understand correctly then perhaps this will help.
1) Populate P5:AC796 using: =MOD(A5,10)
2) Find and replace all periods (decimals) in AE4:BP4 with commas
3) Populate AE2:BP2 using: =LEN(AE4)-LEN(SUBSTITUTE(AE4,",",""))+1
4) Populated AE5:BP796 using: =IF(COUNTIFS($P5:$AC5,RIGHT(AE$4))>=AE$2,1,0)
5) Get the total count in row 3 (AE3:BP3) using: =SUM(AE5:AE796)
Note that you could hide the values in AE2:BP2, for aesthetic purposes, by changing the font color to white.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Ok jeteMC c it's perfect, great work, so the string can be seen as a nano filter Congratulations, artwork, the best is missing a zero value when you win a prize will be rewarded 20%
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks