Which two teams qualify to next stage? [Excel Homework]
Time for some soccer fun in spreadsheets. Given a team points table like below:
How would you figure out in Excel, which teams qualify for next stage. The rules for this exercise are,
- Pick the top two teams by points
- If there is a tie, use Goal Difference (GD) to break ties (more GD is good)
- If there is a tie, use Goals For (GF) to break ties
Note: these rules are only a sub-set of actual FIFA rules. But hey, we are not running soccer competition here. Just having fun, so let’s keep it simple.
In the above example, your answer should be 1 & 2 against Brazil and Mexico in column G.
Download this example points tables and use it to figure out the solution.
You may use formulas, VBA or Power Query to figure out the answers. If using Power Query, assume the input is just a 4 row table with column names, as shown above.
Go ahead and post your answers in the comments section. I am waiting to see all creative ways to attack this problem.
Want more soccer fun?
More Excel challenges & homework problems
- Calculate the employee bonus
- Does this number have repetitive digits
- What is the most frequent item
- How many Friday the 13ths are in a year?
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Excel Tables Tutorial & 13 Tips for making you a Data Guru||How to use Date & Time values in Excel – a handy guide »|