Play 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: