I need to randomize a list into 3 separate, evenly distributed blocks.

Question

I have a list of 15 numbers and I need this randomized into 3 different groups, each group containing 5 numbers.

I have tried the =randbetween(1,3) in Excel but it does not give me 5 numbers in each group.

Can anyone help me with this?!

Thanks.

Answer 1

=INT(3*RAND())+1

will give you a random number of 1, 2,or 3

put this in a row next to the list.

then just setup IF statements. such as =if(b3=1, --,--)

.