Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy messy solution. Glad I got there, even if not the most straight forward way.
Couldn't resist an iterative macro to make it dynamic! Video solution here: https://youtu.be/klLtzDyCEag
Really wanted to use an iterative macro but got stuck and spent way too much time trying to figure it out. May come back to it later and try again. Thanks to @brandon_bunney for the assistance.
I learned about Dynamic Select! (after I solved) -- would have removed the lower joins.