Schedule Randomizer

[Guest]

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

 

[Guest]

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

Anyone..?

thank you.
Lou