Friday, March 27, 2015

yogi_Delineate MakeUp of Teams With 1 Player From Each Of Tiers Specified in Cell D3 and Number Of Students Listed In Cells A2:A


                                           Google Spreadsheet   Post  #1932
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 27, 2015
question by Mar Cel:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/aaD4h6iGZcc
Random selection of team members based on tiers
I'm trying to figure out how to randomly select students to assign to a team but based on one student from each tier. So a student per tier per team. If there are extra students then a last team is based on students from the last tier. 

There's a manual example in this editable sheet below.
---------------------------------------------------------------------------------------------------------


No comments:

Post a Comment