Randomly Assign Employees to Groups of Two Without Repeating
Posted on 2014-10-26
Good morning Experts! I hope this is a simple question and that I'm just having some trouble wrapping my head around it. I need to create a simple application (either in Excel or Access - though I suspect Access will be the better choice) that will allow me to randomly split up a group of 18 employees (that number will change over time) into working groups of two each day. No two employees should work together again until every employee has worked one day with every other employee. I'm able to create the tables and the forms that I need to do this, and I'm able to write the VBA code to make it happen if I can just get the formula for doing this straight in my head.
Thanks in advance for any help you can offer.