# 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....

How can I get this with calc formulas? Thank you

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:Thanks for the comment keme here's the file https://we.tl/t-13ivnMn2qp