Hi all,
I've been working on this problem for several days now and have decided to give up and see if I can get some help. My situation is this: I have the standings from a soccer league, and I want to display them in the correct order (first place through twentieth place). I have attached a file here with all the information needed. The way to determine which team is in which place is as follows:
1. Most points (column C)
2. Greatest goal differential (column J)
3. Most goals scored (column H)
4. Alphabetical by team name (column B)
So in this case, TeamA and TeamB should really be in first and second place as shown here, but TeamD should really be in 3rd place because it has the same amount of points as TeamC but a greater goal differential.
It would be quite easy to accomplish this task using a sort on all these cells. I would simply include four levels in the sort as I outlined here above. The problem is that for my purposes I need to accomplish this using formulas. I have made various attempts at this using the RANK formula, but haven't been able to get my whole task done.
Thanks in advance for any help you can give me and please let me know if any of the above is unclear.
Thanks,
Mike
Bookmarks