How to Draw Names from a Hat Using Excel
Channel: ForeverMore Training
Date: 2022-02-04

Use Excel to draw names from a hat. This is a neat trick to use in a meeting or the classroom when you want to randomly assign a topic. Or draw secret santas, assign chores, work assignments - the uses of this formula are many!
In my class, I assign a topic to the students for a presentation assignment. 
From a list of topics I have created, I randomly assign to a student. It’s like drawing from a hat, but this is automated and fun!
In this video, you will see the Rand function and nested functions Index and Rank.EQ.
Contents
0:00 - Introduction
0:30 - Part 1: How to randomly assign a topic
5:12 - Part 2: Record a macro
7:26 - Part 3: Assign a macro to an image

I am using the Excel 2019 version in the video, but this will work for most versions of Excel.