Hey Excellers Happy Friday. You can download the sample file for this Excel tip here
[ddownload id="7101"]
Today let’s look at some formula fun. Lets use Excel to pick a winner from a list of names. Why not?. It can be done.
Firstly take your list of Names- don’t worry about the order they are, after all they are random!. I have entered 10 names, but of course there could be thousands in reality.
We can combine two Excel functions INDEX and RANDBETWEEN to get a cool result. The Syntax of the formula we will use is
=INDEX(list of names,RANDBETWEEN(first row number, last row number))
In our example it will look like this
=INDEX(B5:B14,RANDBETWEEN(1,10))
Index looks at the list of names in B5 to B14, the RANDBETWEEN 1 and 10 instructs Excel to pick between row number 1 and 10 and return a random value. Cool huh? You can also to refresh the formula hit F9 and this will recalculate the formula and generate another random name.
Give this a go, and share if you use any other Excel formula to generate a random value.
Want To Watch The Video?