Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI spent a long time going on completely irrelevant tangents before finally giving in and looking at the hint! The only thing I can't work out is why there is so much duplication in the output for my Macro, but that's easily resolved with a summarise tool! Video solution here: https://www.youtube.com/watch?v=0-ZbWH9dZio&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=50
This was a real brain teaser.
Thanks for this challenge @PhilipMannering
its not the exact answers but it does create unique pairs.
PS: let me see how was the solution workflow built to get those answers.
Cheers and Happy Analyzing 😀
Merry Christmas🎅
No macros. 'Advanced' dynamic solution. Used 8 tools.
Quite interested in possibly shorter solutions.
Great challenge.
Found myself heading down the macro-rabbit-hole with this one and then pulled up before flying into the mountain. Ultimately solved the challenge and then rethought my approach creating a generic answer that will work for both even and odd counts of people (the odd scenario removing the bye each week). All in all pretty slick!