Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIn looking at some of the others after I did this and right before I posted I feel like I went at this from a very complicated view but then again there are a million different ways in which once can achieve the same result.
I ended up changing the file types to .xlsx due to issues with drivers related to reading in .xls files.
May not be the most optimal solution but I was able to get to the desired result :)