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.
Bookmarks