Attempted to rank using multi row formula, but couldn't get it to work. Ended up having to refer to solution. I just have a hard time conceptually with summing & re-joining at this point. I'm sure I'll get there with more practice.
I used the multi row formula tool with an additional formula applied after to get the rank to start at 1 instead of 0. I also added in the tile tool (seen in other comments) just as a check since it was my first time seeing that tool.