Random Number Formulas

C

carlstedt

It's easy to generate a random number between 1 and 20 (in this example)
with "=randbetween(1,20)" . However, with this formula a number may
be duplicated.

How can a random number be generated so that no number is repeated ?
In other words, how do I enter the formula to create unique random
numbers between 1 and 20 ?

Thanks !
 
T

Tom Ogilvy

Sounds like you want to shuffle 20 numbers

In column A, enter 1 to 20
in column B put in the formula

=rand()

then select A1:B20 and sort on column B.
 

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

Weighted randbetween text list 3
Random Number 2
random numbers 7
Stop Re-calculating Randbetween 2
random number generation help 3
Non Uniform Random Number Generator 2
Unique Random Numbers 27
Random Number Genarator 5

Top