Grouping by Lottery Without Repetition

An Excel file that teaches how to perform Grouping with Random Selection operation.

Excel Source: Grouping By Lottery Without Repetition

A new sequence is produced by shuffling the list. It is designed so that each person is assigned to only one group. The result distribution is shown on the table.

Hope it is useful.