How to Select Multiple Random Winners for a Prize Giveaway

HOW TO SELECT MULTIPLE RANDOM WINNERS FOR A PRIZE GIVEAWAY // See how to use XLOOKUP to select multiple random names from a list without duplicates. In this video, we look at how to use RAND and RANK functions for our XLOOKUP table that will display random names from our list in Excel. Be sure and checkout my other video on how to select a single winner from a list (random number generator): https://youtu.be/l2wTHJD1rJU This can also be used to select employees to work a shift or select volunteers from a list, or how to select an employee of the month.
_________
VIDEO TIME STAMPS - JUMP TO
00:00 Introduction - XLOOKUP Tutorial
00:26 How to Get a List of Names in Excel
00:42 How to Set Up RAND and RANK functions in Excel
01:20 RANDBETWEEN is a Volatile Function that Automatically Recalculates
03:10 How to use XLOOKUP in Excel to Return Random Name from a List
__________
RESOURCES & GEAR
🖱 Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
✦ Green Screen: https://amzn.to/2DnHsY2
✦ Camera: https://amzn.to/39KvpQA
✦ Live Stream Tool: https://amzn.to/2VFJyID
✏️ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
💻 PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=

Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/875846662/employee-engagement-survey-ms-excel?ref=listing_published_alert
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS:
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
__________
KEYWORDS: #MSExcel, random number generator, how to set up random number generator in Excel, how to select an employee of the month, how to select random winners for prize giveaway, auto select names from a list in Excel with no duplicates, how to use XLOOKUP, XLOOKUP Example, XLOOKUP tutorial, pick random names from a list with no duplicates, Excel Tutorial, Excel Functions, How To, advanced excel tricks, Excel tips and tricks, Microsoft 365, learn Excel, prize, giveaway, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM

➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR

Видео How to Select Multiple Random Winners for a Prize Giveaway канала Sharon Smith