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:
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.
Thank you very much dscheikey! I was trying to do it with just one formula, yours is a great solution!
