Random Number Generation
 

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.

Random Number Generation
 

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.

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.