This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackDecided 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!