Hi
I have a Pivot table that shows data from a range of years of a competition.
Is it possible to filter the table so that I can just show the highest value (and therefore the yearly champions) for each column?
The rows are the competitors and the columns are the competition years.
Champion each year is the person with highest point score.
Thanks for your thoughts on this.
Neil
Bookmarks