Play Time! Build a Lottery with Spreadsheets

TechsmithWor3358.pngPlay time! How do I create my own lottery or random prize drawing? Of course, you can always list entries on sheets of folded paper, drop them into a hat, and then have a friend reach in to select one. But to build one that can be used anywhere at any time and designed any way you’d like – check out our spreadsheet template “Lottery / Random Prize Drawing.”

When you are ready to randomly pick the winning name or number, simply select “Yes” to the question: Are you ready to draw a winner? Once you do so, a randomly generated name will pop up below!

See below for a 3-minute video:

What is the key function required to create a spreadsheet lottery or random prize drawing generator? RANDBETWEEN

Other functions that can be used include: