Random Number Generation

  • Thread starter Thread starter navel151
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random number generation 4
Random Golf Foursome Generation 3
Random Number Genarator 5
Generating random numbers from a given range 12
Non Uniform Random Number Generator 2
Copy Matching Numbers To New Cell's 5
Produce Random Numbers 6
random mumber array 3

Back
Top