Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video I share some results from our Excel Equal Playing Time Challenge. We had over 40 submissions and have added screenshots, descriptions, and downloads of each file on the blog post.
https://www.excelcampus.com/tips/equal-playing-time-challenge/

The challenge was to give players on a basketball team equal playing time if there are 12 players on a team, 9 periods in a game, and only 5 players playing in each period.

It was a tough challenge with no perfect solution. However, we had a lot of awesome submissions that used a variety of different Excel features including Excel formulas, pivot tables, macros (VBA), conditional formatting, Power Query, and more.

I hope this is a great learning resource for everyone.

In the video I highlight a few solutions. Again, I apologize that I was not able to show everyone's solution, and really appreciate your participation.

Please leave a comment below with questions or suggestions.

Thanks again and Happy Holidays!
00:00 Introduction
02:25 Waynes Solution
03:35 Cesar Solution
04:33 Diane Peacock Solution
06:09 Eugena Herrera Solution
06:51 Fred Bennett Solution
07:51 Willy Stevenson Solution
08:49 John Witter Solution