Randomly Assign Names to Groups - Excel Formula

Опубликовано: 21 Август 2018
на канале: Computergaga

152,980

729

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!

LinkedIn ►   / 18737946
Instagram ►   / computergaga1
Twitter ►   / computergaga1