Anon,
yes, this is possible, I've done it with the current Premiership and Div 2 footie leagues
In a nutshell, points are awarded if team scores more goals than team b and shared if they are equal. This forms the basis of the league ranking, defaulting to goal difference if their points are equal, so you'd need to factor in goals scored and goals conceded.
if you put these scores in seperate cells, you can use this as a basis for allocating points and goal difference.
try thinking about having all yoru teams down one axis and along another axis (say 10 x 10)
this leaves you with 100 cells, or 100 matches, less the 10 where each team can't play themselves - you'll end up with a grid of home and away ties into which you can slot your scores.
You can then interrogate these 100 slots with =if functions to gets goals scored, goals conceded and points earned
then you can sum them for each team and consolidate this info in a summary.
However, as leagues generally look better with the best team at the top and Celtic at the bott, ooops, I mean the worst team at the bottom, you need to sort this info by points and goal difference.
Research the =RANK function which will achieve this objective without the need for any manual sorting or macros for sorting
key functions would be :
=IF
=RANK
=VLOOKUP
and a lot of trial and error.
However, having done the trial and error a few times now, I can guarentee you can produce an automatically-updating league table, sorted top to bottom, in a single sheet with just those 3 formulae and the usual favourites like + / - / x
Have a think - if you really can't figure anything out and Jack doesn't send you a premiership league table, give me a shout and I'll send it to you to let you see the mechanics of it