Compute rank within each divison

Attached is a sample of the output I get from the program that maintains wins and losses for league teams. A - H are actual output in the format I get it in. I've added column I to tell me when the division changes and column K to tell me if there is a tie within a division. What I would like is a formula to create the rank for each team in it's division (or to mark it tied). I've manually done this in column I. I thought that RANK would do it, but different divisions have different numbers of teams so I would have to manually (I think) create the range for each and that's just as much work. Is there an easy way to get excel to do it for me?