Football League Table

Hi everyone,

I've been trying to do a football league table that updates automatically. I've all the games that have been done in this league in the same worksheet. I want the table to "recognize" if team A won the game against team B and according to the amount of points of each team they move up or down on the table. I want something like this: http://www.premierleague.com/en-gb/m...gue-table.html
I already have a formula that calculates the amount of points of each team according to the number of victories and draws, I just need to know how to make the teams (rows) move up and down.

Thanks,
Falconair

do you have a sample sheet you can upload here

should be able to do a ranking and then create a new sheet with the ranking that will be dynamically linked to your data sheet and change when updated

So this table is supposed to be about the english premier league. The games are in different worksheets, but they can be in the same as the table.

Database.xls

quite a lot of info , i also get a warning on the file
can you explain where i can find this info

I've all the games that have been done in this league in the same worksheet. I want the table to "recognize" if team A won the game against team B and according to the amount of points of each team they move up or down on the table.