|Posted: April 1, 2016, 7:13 am - IP Logged|
You want to calculate a skip table.
Start your table in row 6 (in my example) and column K and fill every number in your lottery (48/49?) in the subsequent columns.
Then, paste the following formula in cell K8 (i.e. leave a blank row below the table header row 6)
Copy across and then copy the row down.
This will give the current skip for each number: 0=last hit, 1=out 1 draw, 2=out 2 draws, etc.
"There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."
~Robert A. Heinlein