I apologise in advance - I am not very good in excel - I can happily copy formulas and figure out how they work but cant make them up for love nor money!!
I have a dilemma I need assistance with - some threads have almost given me the answer but with some bits missing or reams of coding that I dont understand.
I want to make pairings for 10 people so that they each work with every other person over a duration (call it 9 weeks if easier) without any repeating,
I then want to be able to use the same formula for 12 people (11 weeks), 14 people (13 weeks) etc etc up to 30 people.
I have managed to do some manually, but its taking an age.
Any help greatly received (in the most laymans terms possible please!!)
Bookmarks