I'm pretty much a rookie at excel but learn quickly.

To be completely forward I am making excel spreadsheets for my fantasy football league

and we want something we can track, organize and have readily available for viewing each week. Plus to be able to have all those stats going into each new year.

So I am averaging the scores each week for each player in the list.

I am seperating by one row, each sub group (QB,RB,WR,TE,K,Def)

I have a column of averages that I want to take from one page and display on another as a "TOP 24 PERFORMERS" averages from 1st to 24th.

I've been playing with AVERAGE,LARGE AND RANK for hours and want to see if I can get a hand in the correct direction.

All help would be greatly appreciated!

Rory