ndendrinos
11-19-2006, 09:35 AM
Bonjour,
There are 49 numbers and 7 are drawn (6 regular + 1 bonus)
DRJ posted a rather depressing worbook where he recons the odds of LOSING are about 99.95%
I on the other hand am an optimist and intend to WIN !
Here's how and need help:
I will list in A:A 1 to 49
I need a loop that will random pick 6 out of the 49 numbers CUT THEM and transpose them in range B1:G1
Next loop will do the same in range B2:G2 (but now there are empty cells in A:A ... maybe a problem ? ... if so can the code cut and shift up?)
At the end I will be left w/ 1 number in A:A
Not sure how much 6 regular lines and one of seven cost to play but I will play them and post the results.
The visual in DRJ's sample (found under "Lottery") is great ... the numbers can be seen changing at a rapid pace can you please help w/ this too?
Thank you
P.S anyone that helps with this will be remembered in my will
There are 49 numbers and 7 are drawn (6 regular + 1 bonus)
DRJ posted a rather depressing worbook where he recons the odds of LOSING are about 99.95%
I on the other hand am an optimist and intend to WIN !
Here's how and need help:
I will list in A:A 1 to 49
I need a loop that will random pick 6 out of the 49 numbers CUT THEM and transpose them in range B1:G1
Next loop will do the same in range B2:G2 (but now there are empty cells in A:A ... maybe a problem ? ... if so can the code cut and shift up?)
At the end I will be left w/ 1 number in A:A
Not sure how much 6 regular lines and one of seven cost to play but I will play them and post the results.
The visual in DRJ's sample (found under "Lottery") is great ... the numbers can be seen changing at a rapid pace can you please help w/ this too?
Thank you
P.S anyone that helps with this will be remembered in my will