Rand Help

Originally Posted by Bryan Hessey

hmm, another Rand

http://www.excelforum.com/showthread.php?t=584304 has a shuffle, which will shuffle 105 items each time you press CTRL/SHIFT/S
Put the required numbers in column A and you can then select from Sequence!E1 downwards from the list.

hth
---amended, let me adjust this to your needs

shouldn't repeat along the row in the first block, nor down the column in the second

hth
---