• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to identify which teams and their percentage with the highest % of goals scored

VKiprijan

New Member
Hi to all Excel experts,

I want to make a statistic table that will show which soccer teams have the highest prevalence in goals scored when they played against other teams over the whole season. The source of those goals is in the columns P thru Z and the table that will show these soccer teams and its percentage is in AO28:AR39.
Just to give you an example, let's compare which soccer teams had the most frequent number of goals 0-1. If we do the manual count of 0-1 occurrence in column P we can determine that there were four teams with the highest prevalence of 0-1 goals in 8 out of 31 games played (25.81%). That same calculation can be done for other criteria such as 2+, 3+ or more goals per game.
What I need is actually a formula that can count this percentage for me. I am using Excel 2016 so unfortunately, I can't use XLOOKUP function. So, I guess the formula should contain formulas such as INDEX, MATCH, VLOOKUP or even some statistical formula.

I have attached the file for you to review it.

Any idea how the formula should look like?


Thanks everyone in advance.
 

Attachments

  • Soccer League v2.xlsx
    138.3 KB · Views: 0
  • Image1.jpg
    Image1.jpg
    320.8 KB · Views: 0
  • Image2.jpg
    Image2.jpg
    251.2 KB · Views: 0

VKiprijan

As You've read while You selected Forum:
Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here!
Do You have a solution?
or
do this belong to other Forum?

>>> Moved to Other Forum <<<
 
VKiprijan
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
As You have read from Forum Rules:
 
Hi everyone,

I have also cross-posted this topic on the following forums:

https://www.msofficeforums.com/excel/52938-formula-count-goals-total-number-games-2.html

https://www.mrexcel.com/board/threa...l-number-of-games.1265877/page-2#post-6225534

https://forums.excelguru.ca/threads...the-highest-of-goals-scored.11965/#post-49520

https://forum.ozgrid.com/forum/inde...their-percentage-with-the-highest-of-goals-s/

https://chandoo.org/forum/threads/f...ntage-with-the-highest-of-goals-scored.57887/


Thanks.
 
Back
Top