In attached workbook, on sheet DataTable you enter your data. There are helper columns with differently colored headers - you can hide them;
The sheet Hidden contains a helper table, and as the name of sheet says, you can hide this sheet too;
On sheet Rep, you can select age range you want to get report for (which age is lesser or greater is not limited). Depending on selected age range, the max WAR for this age range and list of players who got max WAR in this age range + season of this result are displayed. I designed the report to be able to return up to 10 players listed - you are free to add or remove rows in player list table at will.
|