Coffee Roulette

Hi,

I have a number of teams in my department who take part in a coffee roulette - basically you get randomly paired with somebody else, grab a coffee and have a chat. Im looking to somehow automate the election of the coffee buddy.....

There is only 1 rule - you cant have coffee with somebody in your team. Any ideas how I can automate this? I have a small excel spreadsheet with about 60 names and half a dozen or so team names. Im thinking it would need to be a macro but I've never done one before!

Developer

Accepted answers

afv2688

Hello @craigja,

I don't knwo why it is not working for you. I checked it again and its working fine for me. The only thing that comes to my mind would be if there were an uneven amount of people, like 59 people there would be one extra if I am making groups of two.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

coffee_table.yxzp

All comments

joshuaburkhow

I want to build this for you.... but @ChristineB this so should be a weekly challenge!

@craigja I don't want to spoil the answer so I am going to send you via message (hopefully others do the same 😉 )

joshuaburkhow

Oh forgot to ask, can you provide the data?

craigja

I cant provide the data as such - cant put up the names of all the actual team members but I have mocked up some random names and teams to use to create a workflow

MOCK_DATA.csv

Coffeeroulette123_

Hi I was wondering could you share the spreadsheet for the coffee roulette

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335