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?
Bookmarks