I have a spreadsheet that right now I use to track a FIFA Soccer Tournament (The Gold Cup) being held in the US this month.
There are 12 teams in 3 groups of four. The top 2 in each group will advance from the group stage, and 2 of the third place teams will as well.
Teams get 3 points for a win, 1 for a tie, and 0 for a loss in each match they play. All teams play 3 matches.
So teams are first sorted in descending order of the points they have.
Next they are sorted by goal differential (goals scored for a team - the goals scored against).
The next criteria is the number of goals each team scores.
There are other tie-breakers, but they're not needed right now.
Is there any way I can get Excel 2016 to Automatically sort the teams in each group when I enter their scores in another area?
I will need to do the same thing for all 3 groups. It's just getting over the hump of making the sort become automatic.
Thanks in advance for any help.
Bob
Edit: I added an attachment in the #4 post on this thread. Thanks all.
Bookmarks