How to Create Random Number Generator for Raffle Draw

How to Create Random Number Generator for Raffle Draw (No VBA)

This 15-minute video tutorial will show you how to create a RANDOM NUMBER GENERATOR in excel. What it does is that it randomly selects a value within a range, regardless of how many items/numbers you have on your list.

One best example to use this tool is to assign a winner on a raffle draw by selecting a random coupon code. Using buttons, you will have an option to choose to reset or generate a new code.

The way this tool is being created is so simple, yet its application is really powerful as it truly serves its purpose! Take note, no prior VBA knowledge is required in developing this tool.

Functions used:
Randbetween
If statement

Download practice file:
https://docs.google.com/spreadsheets/...

Good, better, best. Never let it rest. 'Til your good is better and your better is best.
St. Jerome

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
   / @romeocostillas  

YouTube Playlist:
   • Excel Keyboard Shortcut Control Combi...  

Or visit me on Facebook at   / excelbyromeocostillas  

See you there!


Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert


"To EXCEL in the workplace, one must know how to use excel!"
Romeo

Tagalog Excel | Filipino | Pinoy Excel | Excel Tutorial | Excel Tagalog Tutorial

#excel #microsoftexcel #excelbyromeocostillas #excelonline #exceltraining #excelfreetraining #excelmasterclass #tagalogexcel #excelpinoy