I have entered the following equation in L3 of the REPORT sheet to find the player with the highest average score, but although ALT-F9 calculation key gives me 25 for the row (correct - Carver, Graham with an average score of 40) I cannot make the equation give me his name in cell L3.
=INDEX($H:$H,AGGREGATE(15,6,ROW($H$2:$H$136)/((J$2:J$136=LARGE(J$2:J$136,ROWS($1:1)))*(COUNTIF(L$2:L2,$H$2:$H$136)=0)),1))
Bookmarks