Forum Discussion
Random Selection
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...
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
Thanks. the UTube video is easy to follow.