Okebiz Video Search



Title:Pick a Name at Random from a List - Excel Formula
Duration:260
Viewed:192,710
Published:16-12-2015
Source:Youtube

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.

Master Excel VBA with our online course
https://www.udemy.com/excel-vba-cours...

Learn to create sports league tables and tournaments in Excel
https://www.udemy.com/excel-league-ta...

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

Connect with us!
LinkedIn ► https://www.linkedin.com/company/1873...
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

SHARE TO YOUR FRIENDS


Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Pick Names at Random from a List Pick Names at Random from a List
08:30 - 24
How to generate a Random List in Excel How to generate a Random List in Excel
04:22 - 344
Excel Magic Trick 302: Randomly Select Names No Repeats Excel Magic Trick 302: Randomly Select Names No...
03:31 - 144
How to Create a Random Sample in Excel (in 3 minutes!) How to Create a Random Sample in Excel (in 3 mi...
03:03 - 412
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX How to Extract Data from a Spreadsheet using VL...
15:54 - 609
Randomly Assign Names to Groups - Excel Formula Randomly Assign Names to Groups - Excel Formula
09:17 - 35
How to pick names out of a hat with Excel How to pick names out of a hat with Excel
03:08 - 107
How To Make A Raffle Draw On MS Excel How To Make A Raffle Draw On MS Excel
10:39 - 453