Ok...

I wondered if anyone can help me with what may seem simple to someone
of more expeience... ;)

I have a ranking system, with the formulae for one of them

Code:
--------------------
=RANK(K30,$K$30:$K$53,0)
--------------------


This ranks them on 'Points' (its a football/soccer league table). I
have done a Vlookup on them, and all is working fine, ofcouse until two
teams have the same amount of points. I knows its possible to sort this
out, but looks complicated and I dont want to do that yet because thats
not quite the end product I want. Before I do this, (If I need to do it)
I want to (after ranking them by points) rank them by Goal Difference,
and if thats the same then Goals For, and if thats the same then by
Alphabetical order...

I know this is possible by going Data Sort and doing it that way but
I want it to change automatically including places of the teams when I
enter the scores in.

Help would be really appreciated!

Thanks


--
excelnewbieian
------------------------------------------------------------------------
excelnewbieian's Profile: http://www.excelforum.com/member.php...o&userid=37380
View this thread: http://www.excelforum.com/showthread...hreadid=570687