In this video, we look at a step by step approach to randomly assign people to groups with formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper columns, and nesting. We use COUNTIF to verify results.
Comments at: exceljet.net/tips/how-to-rand...