# Excel Challenge 39: Generate Unique Random Values

Deb Ashby

#### Join the Excel conversation on Slack

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

Have you ever wanted to generate a unique list of random numbers? Then it's time to take Excel Challenge #39!

Everything you need to participate in the challenge can be found on this page. To take part:

• First, watch the challenge video and read the instructions below the video.
• Review the previously published video(s) and article(s) on which the challenge is based.
• Put yourself to the test!

Take the challenge!

## The challenge đ¤ş

We are the owners of the ‘Big Jump Skydiving Club’, and we have 23 jumpers on the schedule today.

âď¸STEP 1: Define the jump order.

We need to define the order in which our clients will jump and output their position number in column D.

Things to Note:

• The order should be completely random.
• No two jumpers should share the same jump position.
• There are two formulas that could be used to do this. Either is valid.
• Ensure that volatile functions are removed.

Once we have the positions in column D, we need to sort the list to reflect the final jump order.

âď¸STEP 2: Assign jumpers to a flight.

Next, we need to assign the jumpers to a flight.

Things to Note:

• There are 6 flights today.
• Each flight can carry 4 jumpers.
• If one of the flights is not full, ensure it says ‘Free Spot’ in the cell.

How quickly can you complete this challenge? Fifteen minutes? Ten? Less?

If you need a bit of inspiration, maybe you can pick up some clues from the following video:

If you’re already proficient with Excel, this should be quite easy. Maybe you can tell us a creative way to solve this problem in our Slack channel.

Have fun!

Take the challenge!

## The solutionâ¨

We hope you enjoyed taking part in this challenge! Our expert's solution is revealed below, but maybe you used some other method. Join our community of learners and share it with us.

Stay tuned to the GoSkills Excel Resource hub for more Excel challenges, and check out our range of expert-led Excel courses for all skill levels to further sharpen your skills.