How to Select Multiple Random Winners for a Prize Giveaway

preview_player
Показать описание
_________
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

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
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
__________
FREE DOWNLOADS:
__________
CONNECT WITH ME:
__________
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:

Рекомендации по теме
Комментарии
Автор

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

ericpresa
Автор

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

michaelring
Автор

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.

WillOren
Автор

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

fotografmorteneriksen
Автор

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.

michaelring
Автор

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.

theresaglenn
Автор

hi. why does the value in RAND change?

guiafab
Автор

how about MULTIPLE ENTRIES per person?

ritch