Thanks, Joushua! That's exactly what I was looking for. Sorry for the delayed response.
Glad to help!
I was just replicating this in a workbook that I am using (thank you!), but I have an additional question.
If I wanted to add a feature that dynamically changes the ranking based on the year selected - do you know how to add that? I'm sure it is another parameter, I just can't quite figure out how to get it to work. Any thoughts?