Random selection of a name from a list without repetition - excel

Solved/Closed
b3n01t Posted messages 2 Status Membre -  
jc80 Posted messages 5063 Registration date   Status Membre Last intervention   -
Hello,

I want to create TD groups from a list of 120 students.
These are groups of 5 students with no repetition, and each student belongs to only one group.

I need to make this division into groups randomly for each class (press F9).

Thank you in advance for your help.

Configuration: Windows / Mozilla 11.0

1 réponse

jc80 Posted messages 5063 Registration date   Status Membre Last intervention   1 443
 
Good evening

Look at this address, you have the answer

https://forums.commentcamarche.net/forum/affich-29831370-faire-un-tirage-au-sort-excel-classeur
Best regards
1