close
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
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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=515144
全站熱搜
留言列表
