I have a group of 10 rooms that I am trying to make paths through. Each person has to go to 4 rooms, but it doesn't matter which rooms or which sequence they go in. But at any given time there shouldn't be more than 10 people in a room. Is there a way in Excel to create a random set of rows and columns to do this? I was thinking each person is on a row, then a column for each time block with the room numbers (or letters, doesn't matter) in the column assigned randomly. But they can't repeat, and they have to be evenly distributed. I'm trying to avoid doing this by hand if possible as there are 120 people.
Thank you!
Bookmarks