Repeatable Random pairings without duplicates

[dpkane512]

This issue has been discussed in several older posts but I haven't found a solution that is simple enough for me to use and covers all of the bases.

I am running a training and need to assign random pairs of students twice a week. I don't want there to be duplicates until all possible pairings have been exhausted.
As a bonus, I would like to be able to designate people who will be absent and should be not included in a pairing for that class.

Can someone help me generate a solution for this or point me to one?

 

[NdNoviceHlp]

Hi *dpkanes512 and Welcome to the Board! It seems like you are describing a round robin. Here's a link to some code that should help. Dave

Round Robin

Hi, very new to this so please be gentle. Im trying to make a round robin draw for my local league. 20 players to play each other 3 times, `Ive searched the web and tried all sorts of different things to no avail, please if any help is available would much appreciate it.

www.mrexcel.com