Numerical order would "take away from" the randomness of the drawing. I'm assuming a real lottery would rarely/ever have the numbers come up in numerical order. There is a command to sort a list of numbers though. It is under DATA and then SORT SHEET. You might be able to get rid of duplicate numbers using an "if then" command, but that was more than I wanted to get into with my middle school students who were just getting used to how spreadsheets work.
Is there a way to either sort the numbers in numerical order or make it so the draw doesn't have duplicate numbers?
Numerical order would "take away from" the randomness of the drawing. I'm assuming a real lottery would rarely/ever have the numbers come up in numerical order. There is a command to sort a list of numbers though. It is under DATA and then SORT SHEET. You might be able to get rid of duplicate numbers using an "if then" command, but that was more than I wanted to get into with my middle school students who were just getting used to how spreadsheets work.