Hi, I'm pretty solid with basic Excel functions, but I've been making schedules for a while in Excel and need an easier way to do it. Basically, I have a list of names every few months that goes into an event schedule (around 14 events or so, but I only put in 4 to make it simpler). I'd like to randomize the students completely between all 6 instructors. Preferably I'd fill up the first column (Student 1) of each event with 6 distinct names from the student list, and then any leftover would be randomly distributed into the "student 2" column of that event. (This is to make sure that students get somewhat evenly distributed time with each instructor, and each instructor gets somewhat even days with only one student). In other words, since I have 8 students in this example with 14 slots, I'll have 4 slots unavailable in each event, hopefully for Student 2. I also occasionally need to keep an instructor unavailable for one or both events, so I'd need to know how to leave them out. I could do that manually if needed.
I read a few other posts and am not totally positive where all of this is put into Excel. Thank you for the help!
Bookmarks