Excel League Table

bucks73 · 19-11-2007 8:03pm #1

Hi all,

A friend gave me this excel sheet in conjunction with a league. I only know the very basic stuff on excel so any help would be most appreciated.

The only part Im interested in changing is the actual table. The template was for 8 teams and the league has 11 teams in it and while I was able to add the extra teams I cant seem to create the extra places in the league table.

The info to the right of the table doesnt matter as it wont be included but any help with the league table would be most appreciated.

Inquitus · 19-11-2007 8:48pm

Here ya go

bucks73 · 19-11-2007 9:15pm

Man, you are a legend. I dont suppose its something that can be explained in a sentence or two.

If not, never mind as this is brill.

Inquitus · 19-11-2007 9:18pm

In the fixtures tab I unhid column G which only had the original fixtures in it and copied the formula in it all the way down, so it picked up the new fixtures too.

The league table needed extending and the ranges of several of the formulae extended to account for these changes.

Inqui

bucks73 · 19-11-2007 9:25pm

Excellent. Thanks very much for the help.

bucks73 · 19-11-2007 10:25pm

Sorry about this but would you mind adding one more player. I still cant seem to get the league table correct. Will have to go looking for a tutorial I think.

You could just call him Player 12.

Cheers.

Inquitus · 20-11-2007 6:01pm

Here ya go

bucks73 · 22-11-2007 2:48pm

Thanks again. Much appreciated.

Excel League Table

Comments