random numbers
 

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

random numbers
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515144