Winalot2007
Member
To all Excel experts here:
I created a Pick 3 draw history for every Pick 4 game.
Draw history consists o 50,000 + drawings.
Download link to the text file below:
https://app.box.com/s/yi333l0joba8wqe24e95
The current calculation using Excel for 50,000 plus draws calculating the current "skip" for each set 0000 through 9999 is painfully slow unless you have a super fast computer.
My question is this:
Any way to make the calculation process faster using VBA?
Thanks
I created a Pick 3 draw history for every Pick 4 game.
Draw history consists o 50,000 + drawings.
Download link to the text file below:
https://app.box.com/s/yi333l0joba8wqe24e95
The current calculation using Excel for 50,000 plus draws calculating the current "skip" for each set 0000 through 9999 is painfully slow unless you have a super fast computer.
My question is this:
Any way to make the calculation process faster using VBA?
Thanks