detect the amount of times each lot was drawn in each letter.

[jorel]

detect the amount of times each lot was drawn in each letter,
in the 10 yellow columns we have the total possible in 100% from 0 to 9 or is 120 cracks,
* the macro or vba, will locate the number of times it was drawn
example group A the crack in yellow 156 was drawn 85 times, must be of the same letter
* so it has a range of 120 in each group,
objective = see how many times each
* cracking was drawn,
https://www.excelforum.com/attachmen...1&d=1563557719

[jorel]

hello, please!

[MrGes]

Hello
i didn't understand, the combination 123 in the example turns out to be 45 .... but from where you take this result?

[jorel]

hello MRGes ,Thanks for reading the post.
OK. 45 is an example only
* see = in 0 to 9 we have 120 3-digit formations that are in yellow in each column
* correspondence of the crack and its mirror
* then the macro or vba, will see the amount of each formation the number 45 is only example
* to show that there goes the quantity in each column corresponding to letter
another example training 159 in letter A was drawn 56 times the number 56 is to show the quantity ok

[jorel]

hello MRGES
* 45,12,08, it is just a number to show that there, goes the amount of times that each formation corresponding to each letter in its column
* or you have to calculate the amount of times each trio was drawn
* Of course you will substitute the values 45,18,08, because they are just examples

[MrGes]

Let's see if i understand: the combination 123 in the 10 intervals only count 10 times. It's right?

[jorel]

No, no, the combination of each letter has different values.
you have to compare the combination 123 in its corresponding column

[jorel]

example = column (A) OF THE DRAWINGS, YOU SHALL SHOW THE QUANTITIES OF TIMES, in the collection (A) how many times it was drawn.
* and so on, other letters

[MrShorty]

I will agree with MrGes, I have no idea how you are getting the results you are getting.

Ultimately, the problem sounds like a counting problem ("count how many times each combination in yellow appears in the corresponding columns of results?"), so my first thought is to use a COUNTIFS() function. Something like =COUNTIFS(Q5:Q1836,BN5,R5:R1836,BO5,S5:S1836,BP5) will count how many times the 1, 2, 3 combination appears in columns Q:S. However, it does not return 45, but returns 380. Unless you can help us understand why the result for group A 1,2,3 should be 45, I don't know if we can help with specifics. I would expect that the final solution will be either a COUNTIFS() function or a SUMPRODUCT() or some other counting function/sequence.

[jorel]

hello MrSHortty almost there, the number 45
* it's just an example value, of course there goes another value after adding the times quantity to each its equivalent letter, the value not for nothing is just an example value, ok yes you have to add the quantities

[MrShorty]

I am glad we are closer, but I'm not sure what I suggested that got us closer or what still needs to be done. What exactly do you mean when you say "45 is just an example value"? Are you saying that 45 is the expected result, or are you saying that 45 is just a random number that you put in as a placeholder for the actual result?

[jorel]

hello, yes o 45 is just a number
* without a single value, only
* symbolizing an example, after calculating
* there must be another value of course, the 45,12,08 are fictitious, will be exchanged for their calculations
*

[MrShorty]

So, is the 380 that my formula returned correct? Or, because something smaller might be easier to count, the 1, 2, 7 combination returns 9 and the 1, 2, 9 combination returns 1 and the 1, 2, 0 combination returns 0. Are these all correct?

You have posted this in the VBA forum -- how does VBA fit into the question? Assuming my formula is correct, it should easily copy down and across with the right combination of relative and absolute references (really only need to fix the row numbers in the Q, R, S references), so I don't see that VBA is necessary. What do you need VBA to do?

[AliGW]

Based on experience, Jorel will expect you to provide a workbook all set up for him.

[jorel]

ok, yes, this is correct, I do not understand excel, I need the very experienced
* which dominates this.parte.dever ver vera quantity by correspondent letter, probably the three mirror has the same value
* of the lottery.

[MrShorty]

Which part of this solution are you having trouble understanding?

COUNTIFS() help file: https://support.office.com/en-us/art...c-aa8c2a866842
Relative and absolute references: https://support.office.com/en-us/art...e-5f0d8d0baca9

or something else.

[jorel]

hello Mr, perfect, good job thanks, i'll try