I would much appreciate it if someone could help me with the needed formulas for this case.
I have multiple matches that I want to determine their winners based on their score. I also want to do a couple of stats based on the results.
A sample of how the game result should be entered
My requests are:
1- Return winner team name based on the original time result, if a tie then the extra time result, if a tie then penalties result. I also need the winner cell to have no values if no game result is entered.
2- If the game ends in original time, OTC counter increases by 1.
3- If the game ends in extra time, ETC counter increases by 1.
4- If the game ends in penalties, PC counter increases by 1.
I am guessing the counters would be done using the same method but you are the expert here.
Thank you so much for your time and effort.
(This information is too big to fit a comment, hence I put it as an answer)
I don't think you'll get answers on this site, as you have not done any effort yourself. But I have the impression that this is due to the fact that you don't know where to start, so let me give you some starting advice.
The functions you'll need to perform this task are mostly Max(), Sum(), IF(), CountIF() and maybe SumIF() (or CountIFS() and SumIFS() in case of multiple criteria).
As for the finding of the winner, you might use the Max() function in order to find the best result, and use a Lookup() function in order to know where you might encounter that result.
It might be helpful to add a helper column, containing a value (like 1) for all winning teams. By adding all those ones, you might fill the information in your other columns.
Now you have a starting point. Please try this out and if you have any specific questions, feel free to ask.
