Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADecided not to look at the wikipedia page as an idea hit me straight away so the logic may be different but it works. Made a batch macro to do this but I could have easily made it an iterative one.
This solution will work for any even number of people. I enjoyed this.
Matches criteria where no pairing is repeated
Implemented the Wikipedia solution in Alteryx, but it will work for even or odd numbers of people 🙂
([Max]-1) != ([Engine.IterationNumber]+1)
Just for fun, an implementation of the Schurig table method, which will work for odd and even counts.
Finally posted the answer to the question I set. See my non-iterative macro solution attached,
Was a bit challenging to get my head around at first but understanding the rules for the wiki helped!