Excel Challenge 23: How to Break Ties When Ranking

In this month's Excel challenge, we pit the old against the new! Tell us what to do when ranking gets problematic because of duplicate values.

To get started,

1. Watch the challenge video. 
2. Download the Excel worksheet. 
3. Complete the challenge task.
4. Share your solution, discuss, or ask for help in our Slack channel.

The Challenge

To summarize:

1. What method(s) can we use to identify the top 5 agents based on their Quality Score?
2. How do you handle when we have more than 5 agents with the top 5 scores?

Do you think we should use Dynamic Array formulas? Or are you more old-school? What are the pros and cons of each method? 

Share your take on this challenge before you check out my solution.

I hope you'll enjoy working on and talking about this challenge!

The Solution

We hope you enjoyed taking part in this challenge!

It's Your Turn

Do you have an Excel brainbuster you came across recently? How did you solve it? Join our Slack community and share it with me! Maybe we'll feature it (and you 😉) on an upcoming monthly GoSkills Excel challenge!

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

If you enjoyed this challenge, you’ll love our Basic and Advanced Excel course, which will help you learn more essential formulas, functions, and practical, real-world Excel skills.