Footy Stats

Hello,

I am trying to create a spreadsheet to better track my teams stats. Thanks to this great forum I already am able to randomise teams based on ability, but I would like a way to track peoples goals and assists, and present that in another table that shows the the top 5 of each.

also if possible an equation that lets me input the players rating for a game and calculates their average ability.

I know I'm asking for the world and everything in it, but any tips or ideas on who to write this out would be much appreciated.

Thanks for your time.

Tom