# Excel Challenge 43: Assign Random Values From a List

Claudia Buckley

#### Join the Excel conversation on Slack

Ask a question or join the conversation for all things Excel on our Slack channel.

Have you ever needed to create a random schedule or assign tasks dynamically without manual intervention? Whether you're managing team activities, planning events, or simply experimenting with Excel's powerful functions, this challenge is for you!

Submitted by Judes Jeromin, a member of our Slack community, this Excel challenge focuses on generating random values from a list and dynamically displaying schedules. Do you have what it takes to solve it? Here are your next steps:

• Watch the challenge video and read the instructions below.

Take the challenge!

Remember to share your progress in our GoSkills Learners Community on Slack and swap tips with other Excel pros.

## The challenge

Four athletes have decided to do four training activities every day for August: swimming, running, cycling, and hiking. To keep things interesting, they want their daily schedule to be generated at random. Your task is to create a schedule that assigns random activities for each athlete for the entire month, using Excel formulas—not manually!

But that's not all. There are three tasks you need to complete:

### Task #1: Create a random schedule

First, create a schedule that randomly assigns activities to each athlete for every day in August. Can you determine the best Excel formulas to achieve this?

### Task #2: Create a drop-down list for viewing rosters

Next, set up a drop-down list so someone can select an athlete and a date, then view that athlete’s roster for the next seven days. Imagine how handy this would be for printing out personalized schedules!

### Task #3: Handle dates not on the schedule

Finally, ensure that if any selected dates are not on the schedule, the roster shows "No schedule" for that date. How will you make sure your system handles this gracefully?

Take the challenge!

## The clues đź•µď¸Ź

Ready to crack this challenge? To help you get started, you might want to revisit working with dynamic arrays and creating a drop-down list in Excel. We'll say no more—good luck and have fun!

## The solution

So, how did you do? Were you able to create those schedules? Dive into our solution below and let us know if you thought the same or took a different approach.

Did you enjoy taking this challenge? If you want more Excel practice, we have a whole set of Excel challenges designed to enhance specific skills. Plus, our Excel Resources hub is packed with tips, tricks, and detailed tutorials on the most important Excel functions and tools.

To further sharpen your skills, check out our Basic and Advanced Excel course, which will take you from novice to ninja in no time. Looking to develop other Excel skills? Explore our entire library of expert-led Excel courses and find the perfect one for you.

Until the next challenge! đź‘‹

Ready to become a certified Excel ninja?

#### Join the Excel conversation on Slack

Ask a question or join the conversation for all things Excel on our Slack channel.

Claudia Buckley

Claudia is a certified Microsoft Office Expert (Excel Specialist), project manager, and business skills instructor at GoSkills who has spent over 20 years in employee professional development. Claudia has a Masters Degree in Business Administration and a Diploma in Educational Psychology. In her spare time, she listens to audiobooks and is an amateur genealogist. View her profile here.