All "draw-style" games can be simulated in the same way. They rely on
drawing without replacement. Say the rules for a lottery are there are 50
balls numbered 1 thru 50. Five balls are drawn at random.
In A1 thru A50, enter 1 thru 50.
In B1 thru B50, enter =RAND()
Sort cols A & B by column B. This will "shuffle" the values in column A.
Use the first 5 (A1 thru A5)
For another draw, just repeat the sort.
Change the ball numbers and number of balls drawn to match your particular
lottery.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
