This particular schedule (or rota) does not need to take in people's
availablility, and yes, the randomness is what I need, but how can you
get Excel to pick 15 numbers and put them randomly on every line of a
15x15 grid, so that no number (sequentially) is next to another?


--
dataheadache
------------------------------------------------------------------------
dataheadache's Profile: http://www.excelforum.com/member.php...o&userid=27734
View this thread: http://www.excelforum.com/showthread...hreadid=472444