Channel: Excel Campus - Jon

Category: Education

Tags: excelexcel tutorialpower querypivot tablesconditional formattingdynamic array formulasvbaexcel challengeexcel campusexcel formulaslambda functionlet function

Description: 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. 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! 🎉