I think Rep2 does what you want.
Btw, Mickey Mantle example data didn't contain age 27. So Ty Cobb will have max total WAR for age range 22-27 instead.
The season in report is earliest one for this player in age range. You can modify formula for column R2NameWarSumRow to get player seasons reversed (...[Season];">=" & [@Season]...) - then latest season in age range will be returned instead.
To get all players with max total score and all their seasons in selected age range listed in report, additional helper column(s) is/are needed (you need to number all rows for all players with max total WAR in some order). When you want this, than the example must have given enough clues for you!
|