Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution:
Voila
My solution - after I got to the desired output I got a bit carried away and also did the lines in the top episode broken down by character...
Ok, I spent ENTIIiiiiirrrrely tooooooo much time embelleshing the requirements, adding counts, and putting the results in report formats. I actually created 2 full categories, one for "LINE" counts, and a separate one for "WORD" counts. I definitely could have kept going and added polish to the reports (headers, footer, etc) but figured I'd already kind of beat this horse.