Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 03 Aug 2020 00:18:24 +0200Count how many times each team got max points in a matchdayhttps://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/ Hello I have a calc file containing the calendar of a fantasy football competition.
I have the results and the points each team has got in every single matchweek
I'd like to get the **numer of times each time got the highest points** (in columns B and C and H and I
In the example, the first matchweek max is RagazziSpeciali....
![image description](/upfiles/15963003677101063.jpg)
How can I get this with calc formulas?
Thank youSat, 01 Aug 2020 18:51:08 +0200https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/Comment by danilou2 for <p>Hello I have a calc file containing the calendar of a fantasy football competition.
I have the results and the points each team has got in every single matchweek</p>
<p>I'd like to get the <strong>numer of times each time got the highest points</strong> (in columns B and C and H and I</p>
<p>In the example, the first matchweek max is RagazziSpeciali....</p>
<p><img src="/upfiles/15963003677101063.jpg" alt="image description"></p>
<p>How can I get this with calc formulas?
Thank you</p>
https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/?comment=258203#post-id-258203Thanks for the comment keme
here's the file https://we.tl/t-13ivnMn2qpSun, 02 Aug 2020 12:03:31 +0200https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/?comment=258203#post-id-258203Comment by keme for <p>Hello I have a calc file containing the calendar of a fantasy football competition.
I have the results and the points each team has got in every single matchweek</p>
<p>I'd like to get the <strong>numer of times each time got the highest points</strong> (in columns B and C and H and I</p>
<p>In the example, the first matchweek max is RagazziSpeciali....</p>
<p><img src="/upfiles/15963003677101063.jpg" alt="image description"></p>
<p>How can I get this with calc formulas?
Thank you</p>
https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/?comment=258200#post-id-258200Most likely a pivot table is what you need. This requires a bit of data reorganizing, which would be fairly simple if we have the data at hand. With only a picture of the data, we must first type it into a file, before we can even start to devise a suggestion.
**Help us to help you:**
- Edit your question (see the [edit](https://ask.libreoffice.org/en/questions/258145/edit/) link below your question).
- Attach your file (use the paperclip tool).Sun, 02 Aug 2020 11:16:36 +0200https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/?comment=258200#post-id-258200Answer by dscheikey for <p>Hello I have a calc file containing the calendar of a fantasy football competition.
I have the results and the points each team has got in every single matchweek</p>
<p>I'd like to get the <strong>numer of times each time got the highest points</strong> (in columns B and C and H and I</p>
<p>In the example, the first matchweek max is RagazziSpeciali....</p>
<p><img src="/upfiles/15963003677101063.jpg" alt="image description"></p>
<p>How can I get this with calc formulas?
Thank you</p>
https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/?answer=258233#post-id-258233Hi danilou2,
that wasn't so easy. I was unable to create a matrix formula that could solve your question in one formula. I had to use help columns because your data is not in a very formula-friendly form.
Nevertheless the problem is solved. You can hide the help columns at any time, if they disturb you at that point.
For questions, you can always comment this answer.
If my answer answered your question, please mark the answer with a small check mark next to the answer.
[modified document](/upfiles/15963843405740232.ods)Sun, 02 Aug 2020 18:06:42 +0200https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/?answer=258233#post-id-258233Comment by danilou2 for <p>Hi danilou2,</p>
<p>that wasn't so easy. I was unable to create a matrix formula that could solve your question in one formula. I had to use help columns because your data is not in a very formula-friendly form.
Nevertheless the problem is solved. You can hide the help columns at any time, if they disturb you at that point.
For questions, you can always comment this answer.
If my answer answered your question, please mark the answer with a small check mark next to the answer.</p>
<p><a href="/upfiles/15963843405740232.ods">modified document</a></p>
https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/?comment=258261#post-id-258261Thank you very much dscheikey! I was trying to do it with just one formula, yours is a great solution!Mon, 03 Aug 2020 00:18:24 +0200https://ask.libreoffice.org/en/question/258145/count-how-many-times-each-team-got-max-points-in-a-matchday/?comment=258261#post-id-258261