Hi, I'm new to the forum!

Please see the attached spreadsheet where I'm trying to randomize a group of 32 students into classes with 4 students per class (8 groups total). The issue that I'm having is I don't know how to make it where no student takes the same class over a 4 day period. Each student needs to take all 8 classes. I've already done the randomizing part.

For example, on Day 1... the four students listed in cells E8-E11 are taking Class 1. At no point during the next three days should those four students be shown for Class 1. Any suggestions?

Thanks in advance!

Random Student Group Generator.xlsx