Hi,
I have a list of about 600 files and each file needs to be assigned to two reviewers. There are 20 reviewers total, so each reviewer needs to be assigned about 60 files to review. The reviewers cannot be in permanent pairs. In other words, I cannot have Reviewer A always reviewing the same files as Reviewer B. The goal is to have different pairs randomly assigned reviewing the different files.
Does anyone know of a formula or other Excel solution that could help me assign the reviewers so that each file is assigned a random pair of reviewers and all the reviewers receive an equal number of files to review?
Thanks,
Alyssa
Bookmarks