Excel VBA code - My little contribution

Reply #2

Lucko — Wed, 21 Nov 2018 19:28:41 GMT

Hi dr San,

I am new here so I can't put a link. What I can tell you, if you use correctly my macro, you will see that the numbers come out from the largest to the smallest number. You can use the function nb.si to find out how many times the numbers has been out. The position of the numbers is determined by its output.

You can also make setting to obtain numbers larger than or smaller than X number. You can use it to make a combination with the numbers that have most often come out de... [ More ]

Reply #1

dr san — Wed, 21 Nov 2018 19:06:55 GMT

hello LUCKO, very good job, can you do the most frequent, by position upright?

another macro, of the least freqeunte in general and in the positions?

and also in a particular group of numbers

example = I type a group of 10 numbers of my lottery

31/7, macro goes what else was raffled and what less

in a selected group within a lottery, type a quadrant

Excel VBA code - My little contribution

Lucko — Mon, 19 Nov 2018 14:16:48 GMT

I use this code to find the most frequently issued number from past combinations. Can be adapted to any lottery. I use it for Keno. This is my little contribution to this forum. Maybe someone already published it. If so, accept my apologies.

To be put in an Excel module:

Option Explicit

Sub Frequency()

Dim t, i As Long, j As Long, Dico, Cl , tmp1, tmp2, OK As Boolean, T2

With Application

.DisplayAlerts = False

.ScreenUpdating = False

.EnableEvents = False

.CutCopyMode