I'm working on assigning people to review student applications, and have a list of 16 people who are reviewing, and about 250 applications. Each student should be reviewed by 3 separate people, and everyone reviewing should have approximately the same number of reviews to complete:

250 applications x 3 reviews / 16 reviewers = approximately 47 reviews each.

This is kind of how I'm thinking of setting it up: column A has the list of students by name, and B:D will be the names of the three reviewers. I also have the names of each of the reviewers in F1:J1.

Untitled picture.png

And I'm hoping to have it come out kinda like this:

Untitled picture1.png

I've tried everything I can think of and I can't seem to figure out how to have it be random assignment, equal number of assignments for each reviewer, and also avoiding duplicate reviewers for one student. Also, that second table on the right side is just wishful thinking. I think I can figure that out using a VLOOKUP or something.

Thank you all for any help. Sorry if this is asking for a lot.