macro to add the number of numbers in each column vertically.

[jack]

macro to add the number of numbers in each column vertically. Then mark in a color (it can be red) the amount that gives zero to highlight
https://www.mediafire.com/file/uv46dgh0mawi1k5/4+cores+e+quatro+setores+frank.xlsx/file

 

[jack]

objective = is to locate in my keno 100-20 (lottery), groups of 5 numbers with zero to set up a mirror bet, you can add other filters if you want, you have great ideas, these groups of 5 numbers, there are full groups and empty groups, my intention is to locate those with a value of zero

 

[Frank]

Only about 8 % of all draws have a zero count in all 4 colour zones of your tables. only one draw has two counts of 4 and a count of 3, on row 15.
How you get back to groups of 5 numbers when your grids test in 4 zones is beyond me. Thank goodness Ive finished and left this project.

https://www.mediafire.com/file/0lw6gyt36w1i1tu/4+cores+e+quatro+setores+frank.xlsx/file

 

[jack]

Hello, FRANK, perfect work in Excel, my lottery 100-20 (lotomania) when working with small groups of 5 numbers is more predictable, in groups of zero it would be good to play in the mirror, these groups show hot zones and cold zones (those with zero), the work was perfect! congratulations, thank you