League table in Excel

[Seasider]

Hi,

Just need a little help. I've design a fantasy footy league table that
calculates all the scores etc etc. But I'm stuck how I move the data up
and down depending on each teams points? Is it an easy formula?

 

[Dave Peterson]

Select your range (all the columns in that range)
then data|sort
sort by the total points in descending order.

 

[mooncrawler]

Not so long ago, someone else asked quite the same question, so I made a
simple sample which sorts a ranking list after entering scores.
The file is here:
http://www.geocities.com/smplprgrsrc/files/Football_League.zip
Maybe you can use it.