At 21:13 11/01/2016 +0000, Peter Koch wrote:
I am trying to generate random numbers without duplicate numbers being generated. Can you help me with a formula. I am using the numbers 1 through 69.
This is the same idea as dealing cards from a shuffled pack. So all you need to do is take the set of numbers, shuffle them, and use as many as you require from the start of the shuffled list.
o Enter 1 into a spreadsheet cell. o Fill down the column to 69. o In a parallel column, enter =RAND() and fill that down too. o Select both columns of cells. o Go to Data | Sort... and sort on the column of random numbers. I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
