Uploaded October 2016 | Updated September 2026, 53 minutes ago

---

Another OZ DU SOLEIL Excel challenge!
Oz's video youtu.be/LBBZ5N1YlwY
Oz's main solution was using the incredible and life altering Excel feature GET & TRANSFORM!

My Video:
00:00 Explain Challenge
02:42 Solution Brute Force
04:19 Solution Formulas Only
07:37 Solution Pivot & Formulas

Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com/blog