Help assigning reviewers to applications randomly

[LCLEE00]

Hi!

I am trying to assign reviewers to applications randomly with criteria around duplicates. The following is the particular information and criteria.

INFO: 5 Reviewers, 39 Applications

CRITERIA: Each reviewer reviews max 21 applications, Each application is reviewed 3 times i.e. Each application is reviewed by 3 different reviewers

Any help offered is much appreciated!.

-KLee

[shg]

Each reviewer reviews max 21 applications

If you have 39 applications each to be reviewed three times, and only five reviewers, then they will average 3 x 39 / 5 = 23.4 reviews, no?

[tim201110]

=SMALL(IF(ISNA(MATCH(COLUMN($A$1:INDEX($1:$1,5)),$B2:B2,)),COLUMN($A$1:INDEX($1:$1,5))),RANDBETWEEN(1,5-COUNT($B2:B2)))
confirmation of post2

[LCLEE00]

Yes, SHG that's correct. ~23 per reviewer. I needed help with the formula in excel to randomly assign the reviewers to the applications. Thanks Tim, for the formula help. Any notes you can share on how to quickly duplicate this on my own? I'm copying and pasting the formula but not quite sure how it works.

-LCLEE