Hi Pete,
Thanks again. The order of the cells were more to do with me explaining
the scenario rather than me being on the upside down end of the world.
:)

All worked brilliantly except for one hiccup with the A5, when two
numbers equal each other.

What is happening is that in that, in the instance that a game is yet
to be played and there is no entry in the cells (ie.0-0), the formula
gives a point to the draw column.

This is a problem in that it obviously attributes a draw when a game
has not yet been played.

Thankfully not may draws occur, so if needed I can manually update
these. However, is there a way of telling excel to only calculate if
there is an entry within the cell. So if a cell is blank it is ignored
by the formulas?

Cheers
Shaun in upside down Sydney


--
shaunl
------------------------------------------------------------------------
shaunl's Profile: http://www.excelforum.com/member.php...o&userid=25140
View this thread: http://www.excelforum.com/showthread...hreadid=527886