Randomly Assign Names to Groups - Excel Formula

In this video, we look at randomly assigning names into three different groups using an Excel formula. We look at 2 different examples of doing this. Firstly we quickly assigning twelve names into 3 different groups. Then we look at evenly distributing the names into 3 groups ensuring there are 4 names in each. The formulas to produce random numbers are volatile, so the video shows you a quick tip to convert formula to values also. And some other options. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us!