Challenge #247: Pairing Partners

[AYXAcademy]

A solution to last week's challenge can be found here. Source: https://en.wikipedia.org/wiki/Round-robin_tournament

This week's challenge was submitted by @PhilipMannering  - Thanks for your contribution!

This problem was inspired by a question on the Community forums: 

With remote working the norm, it's difficult to get some one-on-one time with other people in your team. Given the list of names, generate pairings of people for each week. Everyone should have a partner. And no pairing should be repeated.

[Jonathan-Sherman]

Challenge 247 is done, closing down on that 250 badge now!

Workflow:

Spoiler

Batch Macro:

Spoiler

[dsmdavid]

I can only think in (nested) iterative macros this week...

Spoiler

outer iterative - spits weekly combinations The inner iterative generates each week's combination. The outer iterative continues to feed data to the inner as long as there are meetings that have not taken place yet

[Blake]

Mod function and tile tool to the rescue! Great challenge, @PhilipMannering !

Spoiler

[Kenda]

Spoiler

Dynamic solution with iterative macro

[phottovy]

I still want to tackle odd number of competitors but I believe I replicated the "Circle Method" in my macro.

Spoiler

[peter_gb]

Fun one! Started doing iterative but wished to avoid iterative within iterative so just went to wikipedia to be told what to do 😄
Will only work for an even number of people.

Spoiler

  

[mbogusz]

Spoiler

Challenge #247 in the can

[TonyA]

This was a fun one. Very interested in seeing other solutions. Thanks to @Greg_Murray for showing how to capture all intermediate results from an iterative macro in last week's challenge.

Spoiler

[ggruccio]

I found multiple solutions that worked, but don't match the answer provided.  But I validated it manually and my answer meets the criteria....everyone meets and no pairing repeated....