Make A Secret Santa Generator In Excel – Using RAND, IF and COUNTA
Secret Santa is a Christmas tradition where group members are randomly assigned a person to whom they give a gift. In this video we start by assigning a random number to each person in our Secret Santa gift exchange which will later ensure that people are randomly assigned. Using these random numbers we will then decide who gives who a gift, ensuring that everyone receives a gift and no one gets gifted twice. Throughout the video, we'll be using the RAND, COUNTA and IF Functions.
IF Function Excel Tutorial - Test Whether A Condition Holds Using Simple and Nested IF:
• IF Function Excel Tutorial - Test Whe...
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Make A Secret Santa Generator In Exce...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Inputs: (0:37)
Intermediary Calculation: (1:27)
Outputs: (2:03)