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

calc
max

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

danilou2
3 ●1 ●2

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

Comments

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 ( 2020-08-02 11:16:36 +0100 )edit

Thanks for the comment keme here's the file https://we.tl/t-13ivnMn2qp

danilou2 ( 2020-08-02 12:03:31 +0100 )edit

add a comment

Comments

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

danilou2 ( 2020-08-03 00:18:24 +0100 )edit

add a comment

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

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

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

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

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