Ask Your Question

Count how many times each team got max points in a matchday

asked 2020-08-01 18:51:08 +0200

danilou2 gravatar image

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

How can I get this with calc formulas? Thank you

edit retag flag offensive close merge delete


Most 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 link below your question).
  • Attach your file (use the paperclip tool).
keme gravatar imagekeme ( 2020-08-02 11:16:36 +0200 )edit

Thanks for the comment keme here's the file

danilou2 gravatar imagedanilou2 ( 2020-08-02 12:03:31 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-08-02 18:06:42 +0200

dscheikey gravatar image

Hi 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

edit flag offensive delete link more


Thank you very much dscheikey! I was trying to do it with just one formula, yours is a great solution!

danilou2 gravatar imagedanilou2 ( 2020-08-03 00:18:24 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2020-08-01 18:51:08 +0200

Seen: 31 times

Last updated: Aug 02