Random Selection

[jcb29]

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. 

[#2]

Hello @jcb29,

This website might be helpful:

https://www.get-digital-help.com/2010/09/30/team-generator-in-excel/

Hope this helps!
PReagan 

[#3]

@jcb29 

Hi

This is a perfect use of the new RandArray function

If 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-TvvBkQ

Hope that Helps

Nabil Mourad

[#4]

Thanks. the UTube video is easy to follow.