I use a points, goal difference, goals scored, row algorithm to ensure
unique ranking in mine.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"daddylonglegs"
wrote in message
news:daddylonglegs.2ah72n_1152108607.7943@excelfor um-nospam.com...

gdh82 Wrote:
Sorry about that (v. embarassing!)

As for the hidden table, I'm impressed by how consise it is (so much
less convoluted than the world cup spreadsheets I've seen). There's a
number of functions that I haven't used before so I'll need to look
them up to help me understand it (!) but for now could I ask what the
adg score represents ? Thanks again.

Hi gdh, I'm sure Bob can produce something rather superior to mine but
to answer your question....

"Adg score" should really be "adj score" meaning "adjusted score".
Basically the number of points is adjusted by a very small amount based
on goal difference or goals scored which ensures that when there is a
tie on points the team with the best goal difference has a slightly
higher "adj score" and is therefore ranked higher.

Similarly if both points and goal difference are equal then the team
with the most goals scored will have a slightly higher "adj score"
ensuring, again, that the correct team is ranked higher.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557213