Aug 03 2019 12:24 PM
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.
Aug 03 2019 03:17 PM
Hello @jcb29,
This website might be helpful:
https://www.get-digital-help.com/2010/09/30/team-generator-in-excel/
Hope this helps!
PReagan
Aug 03 2019 06:02 PM
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