Pick a Name at Random from a List – Excel Formula

Pick a Name at Random from a List – Excel Formula

HomeOther ContentPick a Name at Random from a List – Excel Formula
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Computergaga2015-12-16 09:06:24 Thumbnail
370,610 Views
Pick a name at random from a list using an Excel formula. This video tutorial demonstrates using the INDEX and RANDBETWEEN functions to pick a name from a list at random.

You may wish to do this for a fun way to decide who is making the tea in the office, or washing up. Or it could be that you have a business situation that requires pulling a random entry from a list.

This technique can also be useful to simulate pulling a name or team from a hat in a sports cup draw scenario.

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.