Random Selection

Question

Need to form eight teams, randomly selected from a group of 90 individuals. The name of each individual can only show up once in all the groups.

Is there an Excel formula that will work for this? Thanks.

preagan · Answer

Hello&nbsp;jcb29,&nbsp;This website might be helpful:https://www.get-digital-help.com/2010/09/30/team-generator-in-excel/&nbsp;Hope this helps!PReagan&nbsp;

nabilmourad · Answer

jcb29&nbsp;HiThis is a perfect use of the new RandArray functionIf you have Office 365 then without a doubt the Dynamic array functions will do it the fastest, easiest and most dynamic way.Here is a short Tutorial on how to do that:https://www.youtube.com/watch?v=NMlb-TvvBkQHope that HelpsNabil Mourad

jcb29 · Answer

Thanks. the UTube video is easy to follow.

Forum Discussion

Random Selection

3 Replies

Resources