E
excelnewbieian
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
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