To produce 1 set of three numbers, type formula in Column (A):
Using 3 columns to produce 1# in each, type this formula, then copy to (B) (C):
To change/generate a different answer, Click F9. You can hold F9 down or just touch it once. It will ask each time you open it, if you want to save…only need to save the FIRST time.
For other lottery games, you can use this formula…just change the “53” to match the number of balls used in the game you are working with:
If it is 5 balls, plus a bonus: insert formula into 5 columns and in 6th-change number to match balls for the Bonus drawing, if different from the first ones.