Coffee Catch ups

[WoonL]

Hi,

Trying to automate a coffee catch up process for the team on a weekly basis without repeating the combinations in

the past. Managed to work out all the combinations, but I'm struggling to produce the new combinations that consist of the everyone on a weekly basis.

Any help would be greatly appreciated!

Thanks,

Woon

[PhilipMannering · Accepted solution]

Hey @WoonL 

Please see attached my solution. It's a bit of a brute force approach, but it should work for any even number of names that you feed it.

Let me know if it works.

Thanks,

Phil

Edit: Adding the 2020.2 yxmd and yxmc files.

[WoonL]

Thanks Greg & Philip! Both Solutions worked for the proposed solution.

(My bad for not mentioning this) However, I have 40+ participants in the actual data, which doesn't work too well with the proposed solutions.

I partially solved it by creating my first iterative macro as per attached. It outputs all the first unique pairs and remove past pairs. Problem - because it outputs the first unique pairs, it might miss one or two pairs from the actual list after a few loops.  

[udles5666]

I had a similar problem like this & this thread helped.  🙂 

[PhilipMannering · Accepted solution]

HI @WoonL ,

Think I found a better solution. Should be able to handle a lot more participants. See attached.

Thx,

Phil