Random Number Generation
Thx, Peter - as always it's something simple that works.
"Peter T" wrote:
If(?) you mean you want all 16 numbers 1-16 in a random order, with no
duplicates
In B1:B16 enter 1 to 16
In A1:A16 enter formula =RAND()
Press F9 a few times
Sort A1:B16 with col-A as the sort key.
Regards,
Peter T
"navel151" wrote in message
...
I need to generate a set of randow numbers but need it to not include any
numbers already generated for the range selected? i.e. Want numbers from
1-16 in 16 cells but don't want any duplicates. Any ideas?
Thx.
|