Schedule Randomizer

L

LOU

Good Day!
I have a sheet structed as such,
Col A Col B Col C Col D Col E Col F Col G Col H Col I Col
J Col K Col L
rw 1 Name WK1 WK2 WK3 WK4 WK5 WK6 WK7 WK8 WK9 WK10 WK11
rw 2 Bob
rw 3 Frank
rw 4 Joe
rw 5 Alphie
rw 6 Bill

I have a 12 week schedule with 22 teams that I need to flow across and down
that mixes the teams up during the 12 weeks so that no team plays the same
one over again. The formula would be in cells B2 thru L6 in the example above.

Any ideas...?

Thank you.
Lou
 
L

LOU

well I guess this is not possible...?
Or my information is not good..?

Anyone..?

thank you.
Lou
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top