Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHello Data Heros, this challenge makes me suffer, I can easily create unique pairs and assign them to weeks, but I cannot produce the same result in the submitted solution, plus this tool "Make Column" is not a production-ready tool,
attached is my solution I believe it achieves the needed (with exception one single person can have multiple meeting in the same week)
(I used iteration macro to create the unique combination )
My solution works for any number of people who have bilateral meetings and it produces a meeting order in randomised fashion
Iterative Macro