Random Number Generation

N

navel151

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.
 
P

Peter T

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
 
Top