Assuming your data, with headers, is in Sheet1, A1:C6.
Now, assuming the results are going to be in Sheet2, starting in A2... and also assuming you can have duplicate AtBats, you will need a way to pull the unique names and averages...
So first use the LARGE() function to pull the top scores.
In A2 of Sheet2:
=LARGE(Sheet1!$B$2:$B$6,ROWS(Sheet1!$A$2:$A2))
copied down to get the number of scores you want.
Then to get the Player names in B2:
=INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6=A2,ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF(A$2:A2,A2)))
confirmed with CTRL+SHIFT+ENTER, not just ENTER and copy down.
Similar for Batting Averages, replacing the INDEXed range.
Bookmarks