I have created a football league table which autosorts the league based on points, then goal difference, then goals scored. This uses the rank and vlookup functions.
However, I would like to change it so that if 2 teams are level on points, then the next citeria will be based on the score between them. Can anyone help me do this - is there some way to lookup a result of a game if two tems are level and points and put the winner highest, but ignore this if it is a draw?
Thanks
One way to do this is to combine a sort as usual with a subsequent macro step which identifies teams that are otherwise at the same level and searches for the score to that they can be reordered if necessary.
This could get a bit complex it you had more than two teams at one level and you end up doing multiple pairwise comparisons in order to determine a winner. If you can determine the set of rules, they could be coded into a macro.
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks