Hi S,
A couple of general observations:
On the first point, for any particular pairing they have either played or
they haven't.
So your formula should be test first to see if they haven't = Blank cell!
If this is not the
case then do a calculation win, draw, loss for each club.
The second point, you need some kind of trigger to run a simple VBA
procedure to recalculate the
formulas and then to sort the LeagueTable range (sorting on Points and
GoalDiff cols). Assuming you
have the table on one sheet and scores on another, my inclination would be
to use the Activate Event (for the table sheet)
to fire off this bit of code. So once you selected the sheet again, after
adding new results to the other,
it would automatically reorder the list/table. Make sure you construct you
formulas so that they always
reference the team in the first column - before and after sorting.
Regards
Paul
S said:
I'm trying to put a football league table together, which i'd like to
include: the team, matches played, won, drawn, lossed, goals for, goals
against, goal difference and points. i've pretty much done most of it but my
main two problems are when there's no score entered for each match it enters
in the table as a draw and my other issue is once a score is entered i can't
get the teams to move up and down the league automatically. is there a way
to lock the formulas for each team when they move up and down?
