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
 
Top