How to Select Multiple Random Winners for a Prize Giveaway

No video

How to Select Multiple Random Winners for a Prize Giveaway

Рет қаралды 26,766

Күн бұрын

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): • How to Randomly Select... 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: amzn.to/3pxpc25 (This is a really cool mouse!)
✦ Screen Recording Software: techsmith.z6rj...
✦ Green Screen: amzn.to/2DnHsY2
✦ Camera: amzn.to/39KvpQA
✦ Live Stream Tool: amzn.to/2VFJyID
✏️ JotForm: www.jotform.co...
💻 PresenterMedia: shareasale.com...
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: www.etsy.com/l...
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: www.paypal.com.... 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 mailchi.mp/6a0... 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: www.sharonsmit... for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / 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: • How To Create A Fillab...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist

Пікірлер: 24

@be4bharat Ай бұрын

Very well explained. 👍

@SharonSmith Ай бұрын

Glad you found it helpful! Thanks for watching!

@rosaa177 Ай бұрын

Thank you, you were easy to follow.

@SharonSmith Ай бұрын

So glad you found it helpful! Thanks for watching!

@ericpresa 3 жыл бұрын

the rank formula isn't working as expected, it's missing the $ on the range reference.

@dfergusonmpa 2 жыл бұрын

Very helpful. Thank you.

@SharonSmith 2 жыл бұрын

Glad to help! Thanks for watching!

@Bagsandthingsbysilvia 3 жыл бұрын

Awesome 👏🏼 thank you 🙏🏼

@theresaglenn5421 2 жыл бұрын

Hi. Thank you for the video. Question - why are their duplicate numbers in the ranking column? Seems like each number should only appear once, but I see lots of #1's and a couple # "3s." Thank you for explaining.

@ericturnquist1970 2 жыл бұрын

I'm seeing the same issue, I have multiple RANK of 1, 2, 3, 4 and 5

@mebermudez Жыл бұрын

Hi Sharon, is there an answer to this question? Thanks

@davekenny9987 Жыл бұрын

As epresa states below, Sharon missed a vital step when copying the RANK formula down the table. She ranked [cell to the left] in a range of,say, d2 to d99. However when she copied it down the RANGE moved, relative to the cell it was copied to. The trick is to use $ to fix the range, or part of it. So instead of ....=RANK(D2,D2:D99) it should have read =RANK(D2,D$2:D$99). Then when it copies down the range would always span 2-99. Hope that makes sense.

@mohammedmaroof3030 3 жыл бұрын

Appreciate

@SharonSmith 3 жыл бұрын

Thanks for watching!

@syedikramullah1114 3 жыл бұрын

Nice

@SharonSmith 3 жыл бұрын

Thanks for watching, Syed!

@michaelring8248 2 жыл бұрын

Once created, can new rows be added and will it still function? Many thanks.

@WillOren 2 жыл бұрын

Any way to get this to return last and first name? We have employees with either same last or same first names. We have the first and last names in separate columns as well.

@fotografmorteneriksen Жыл бұрын

Rank does not accept the formula given here..I got the norwegian version of excel. I use the equivalent formula buut no. Sigh

@guiafab Жыл бұрын

hi. why does the value in RAND change?

@michaelring8248 2 жыл бұрын

Hi, Re: HOW TO SELECT MULTIPLE RANDOM WINNERS FOR A PRIZE GIVEAWAY - Is there any way to lock the resulting 'Winners' until a 'Clear Results' Button is Pressed. Also Placing a 'Recalculate' Button. I believe both are possible but I don't know how it's done.