detect in each sector the corresponding numbers and add the quantity.

detect in each sector the corresponding numbers and add the quantity
* objective = to classify in each sector the numbers
* of each draw line
https://www.excelforum.com/attachmen...1&d=1570276489

hello pci, thanks for viewing the post as well
* this lottery uses 00 to 99 or one hundred numbers
* are drawn 20 (keno type) was divided into 4 quadrants, sector means quadrants or 4 parts
* but are in the 4 colors, the macro will see detect of each draw line its corresponding number can be represented by (x) or (1), and add the amount of each color or quadrant, there is forgotten
* to talk about the 25 positions, amcro has to show also, if there was repetition of positions
* in each draw,
* ex = the 17th apposition repeated in other colors or quadrants

ok that's correct PCI remember that every week I will put new sweepstakes
and formula has automatic make,
on the 25 positions, see if in each draw line, repeat numbers drawn in the same position involving the 4 sectors,
ex = position 1st time 4 repetitions = 01,06,51,56
are numbers of the same position
another example = position 25th da = 45 50 00 repeated 3 numbers of the same position in each quadrant, you have to add the 25 positions side by side
https://www.excelforum.com/attachmen...1&d=1570355679

hello,KVSRINI, ok, that's correct, explored !!! great work, congratulations,
* thank you!