Excel Challenge 39: Generate Unique Random Values

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.
• Download the Excel worksheet you will use to complete the challenge tasks.
• Put yourself to the test!

Want to chat about your approach and process with other Excel-heads? Join our Slack channel to share your insights and questions with like-minded learners.

---

The challenge 🤺

Here’s the scenario to be solved from the download file:

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!

---

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.

If you enjoyed this challenge, try the Basic and Advanced Excel course to help you learn more essential formulas, functions, and practical real-world Excel skills

Ready to become a certified Excel ninja?

Start learning for free with GoSkills courses

Start free trial