Randomly assign to a group with a maximum group size

[sunsoar77]

I'm seeking some help with this task. I've done a few searches but can't find anything I need.

I have 180 guests coming to an event. I want the guests to be randomly assigned to one of 25 possible tables, however I want to make sure that there are only 8 people to table.

I've tried RANDBETWEEN however I can't think of a way to cap the number of assigned numbers to 8.

Any ideas are appreciated.

[JeteMc]

A solution that steals from Bob Umlas' (post #2 in thread)
1) List the 180 names in a column.
2) in an adjacent column enter the =RAND() function and copy down.
3) Sort both columns by the column with the RAND() function.
Now you can assign the randomly sorted names to tables 1 through 25 in order.
Let me know if you have any questions.