Example: I have 1,036 nominees and each one has to be interviewed by 3
different people out of a group of 20 interviewers.

1,036/20 = 51.8 nominees per interviewer
1,036-(51*20)=16
So 16 people would have 52 nominees and 4 would have 51 nominees.
(!6*52)+4*51=1,036
And I can figure all this out ahead of time.

So I use INT(RAND()*20) in 3 columns and 1036 rows.

Of course some rows will have duplicates but I can, in another 3 columns
look at the rows with duplicates and assign another random number to
replace the duplicate, no big deal. In my test case I did this two
times and afterward only had 3 rows left with duplicates.

The problem is that INT(RAND()*20) has no idea that it can only have 51
zeros, 51 ones, 51 twos, etc or 52 instead of the 51, I can manually
adjust for the 4 51s and 16 52s.

In my test case here is what happened
165 zeros
158 ones
190 twos
150 threes
167 fours
142 fives
157 sixes
166 sevens
159 eights
147 etc
170
154
160
141
152
154
154
135
143
147
-----
3111 total random numbers assigned, I only wanted 1,036.

Not cool.

So I have to find something better or someway to limit my command with
another command while at the same time leaving the randomness.

Any ideas?