separate the endings and then detect the 4 patterns, and add the amounts of the last digit

separate the endings and then detect the 4 patterns, and add the amounts of the last digit or ending from 0 to 9
https://www.excelforum.com/attachmen...1&d=1730540089

hello=2 3 5 6 9 0 1 3 4 6 8 0 3 4 5 2 1 2 5 2 1 3 1 3 4 2 0 1 3
1 4 5 6 7 9 ...
0 5 5 6 5 18 1 3 4 6 8 0 3 4 5 2 1 3 6 2 1 3 2 1 3 0 2 1 3
-1 6 5 6 3 27 ...
-2 7 5 6 1 36 1 3 4 6 8 0 3 4 5 1 2 2 5 1 1 2 2 2 4 2 0 2 4
-3 8 5 6 -1 45 ...
-4 9 5 6 -3 54 1 3 4 6 8 0 3 4 5 1 2 2 5 1 2 3 2 1 3 2 1 1 4
-5 10 5 6 -5 63 ...
-6 11 5 6 -7 72 1 3 4 6 8 0 3 4 5 2 0 2 4 1 0 1 2 2 4 3 1 2 6
-7 12 5 6 -9 81 ...
-8 13 5 6 -11 90 1 3 4 6 8 0 3 4 5 2 3 1 6 2 1 3 1 1 2 1 1 2 4
-9 14 5 6 -13 99 ...
-10 15 5 6 -15 108 1 3 4 6 8 0 3 4 5 1 0 1 2 2 1 3 1 3 4 2 2 2 6
-11 16 5 6 -17 117 ...
-12 17 5 6 -19 126 1 3 4 6 8 0 3 4 5 1 2 2 5 2 2 4 2 1 3 2 0 1 3

Hello,TMS! we have a problem. The formula is taking doubles, like 36, 45, etc. It can't be done because it's just one last digit. There are errors in the formula. Can you fix it?

hello TMS! the error is here = There where there are 36, 45 there is no formula.
The formulas are only between AJ and AV
The input numbers have to be 15 endings with only one digit

Two digit number text -> last 1 digit number -> sum by pattern
There is no need Q:AE, you can convert directly, no matter how many digit.

Formula:

Please Login or Register  to view this content.

hello,tms and rhis!!,thanks for seeing the post now it is correct,perfect congratulations,thanks you

Hello, TMS and Rhis, is it possible to count the suits (value of the 4 sums together) how many times each suit has been drawn, the objective is to see which suits are late,
in the list in green are all the possible suits
it was only possible to put the list after doing the 1st part of the suits
https://www.excelforum.com/attachmen...1&d=1730622024

I couldn't catch anything in green numbers.
Please explain your calculation method.

hello tms amd rhis,ok I'll explain, in the green list, it's the combination of each of the 4 sums are all the suits or set of sums, in a group in the referred position are all the possible suits 98% of them from this list the macro will see example 5343 has already been drawn x times, the objective is to see which suits are drawn the most, and see their delays, you have to make the entire list of draws (it's already ready) when I go to put new draws the macro will do it automatically

I didn't understand you explain.
If you want RED cell numbers directly,
you can use this formula, reference data should be above.

Formula:

Please Login or Register  to view this content.

스크린샷 2024-11-04 134321.png

hello,RHIS! almost there, the green list are all the possible suits in red, the macro has to see which red suits are drawn most often, example = red suit = 5343 has already been drawn 120 times (it's just an example) another example red suit 4533 has already been drawn x times, the green list is the combination of all suits

Please remind, I speak KOREAN not ENGLISH...
I cannot understand your explain, make it simple,
do you want to get green colored numbers or any other numbers?

hello RHIS!green numbers is the list of the total of the suits, or group of the sum ok, in the reds the macro will see the number of draws that occurred in each formation of the red suits

hello john, rhis tms !thank you!