Formula Friday- How To Pick A Winner Using Excel


happy fridayHey 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?

Want some more Formula Fun??



Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts