VBA macro: combinations

SHT

Member
Message for Giles or any other excel expert.

I hope you don't mind me asking Giles, but I am trying to determine the frequency of repeating triples in my original lottery data. I was wondering if it would be ok to ask you, if you have a macro that would enable me to achieve my aims?

My feeble attempts to modify your original macro was a total disaster.

The worksheet is arranged as you previously instructed me. But the analysis results for triple combinations is to be placed on a page named "Result2".

SHT.
 
You can achieve far more than triples frequency
with LottoStatisticsXL.

Go to N-tuplets section, adjust Input Fields
and just click the button
 

Irvin

Member
Nick :wavey:

Been tinkering around with your earlier version of LottoDesignerXL and it is brilliant.

Using the constraints options a bit.

Regards,

Irvin
 

PAB

Member
Hi SHT,

I too have been trying to modify GillesD Program to determine the frequency of repeating triples, and, like yourself, have failed miserably :bawl:. If I get time I will have another go at the weekend.

All the Best.
PAB :wavey:
 
Top