Quote:
Originally Posted by VKiprijan
So, which formulas did you use to show this statistics?
|
Well, that picture wasn't the result of a formula, instead I used
Power Query.
In the attached, on sheet
Bundes League (2), at cell L4, there's a result table which you can update by right-clicking in it and choosing
Refresh. It's based on two proper Excel tables: (a) one called
Table1 at B4:H346 and (b) the other called
Table4 at J4:J15, both on that same sheet.
Since then, I developed a deceptively simple
named lambda function
TeamsWithMostPercentGames.
You can see it in action at cell AS28 of the
Bundes League sheet. It needs to be copied down.
2024-10-26_162447.jpg
You can see that it uses only the raw data.
If you want to copy the
lambda function to another workbook, copy that single sheet to your workbook, then immediately delete it from yor workbook. The function should remain. You can see it in
Name Manager.
The rest below is just for information and the relevant formulae can be deleted/ignored:
In cell AW28 is the development version of
TeamsWithMostPercentGames, and the formula in cell BC28 is the forerunner to that.
Now I'll just wait for the questions…