|
Sorry if this has been asked already, but how do I generate a set of 400 numbers from the range 1-1000, without any repeats? Right now I have 1000 entrants that I need to widdle down, randomly, to 400. I ve tried rand() the cell next to the entrant, dragging it down to number 1000. then filter, either ascending or descending, the randomly generated numerical values and taking the top 400 values. I assumes there's a lot more compact and less complex way of doing this. thanks
|
#
¿
Jun 21, 2011 01:08
|
|
|
|
| # ¿ Apr 28, 2024 14:46 |
|
|
^^^^^ thanks for the advice
|
|
#
¿
Jun 21, 2011 15:25
|
|