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?

I don't know. There is no way to do this by formula but it could be done by
macro, except for the "no number (sequentially) is next to another"
requirement. You see, the macro could randomly pick the first number and
then a second (excluding the first and the next number after it) but I don't
see how you can be sure at some point you do not have only sequential
numbers to pick from like 3,4 and 5.

--
Jim
"dataheadache"
wrote in message
news:dataheadache.1wbjmi_1128330331.5265@excelforu m-nospam.com...
|
| 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
|