random numbers

J

John Murf

how do i create a series for random numbers with in a range, using all the
numbers and not repeating any?
Say all numbers from 1 to 15.without repeating any number
 
D

daddylonglegs

You could try this....

put this formula in A1 copied down to A15

=RAND()

put this formula in B1 copied down to B15

=RANK(A1,A$1:A$15)

B1:B15 gives 1 to 15 in random order, hit F9 to re-generate, hide
column A if you wish
 

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

Top