Tony,

speaking personally, the explanation does not make it clear to me.

I assume that each person has twenty players, but what are the numbers
before and after the players meaning, and how does that translate to say the
69 for Tony?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tony" wrote in message
...
Hi,

What would be the best way of building a league table from 75+ teams that
automatcially updates itself when I update player scores. The set up of
each team looks like this (beginning at A1) with each team recurring every
20th row. Player scores are linked to main players table using vloopup
=IF($A2="","",VLOOKUP($A2,Euro2004Players,5,1)).

Tony (Manager name occurs in first row, i.e. A1)
Code Player Team Value Points
8 Kahn Germany 4 69
137 Cocu Holland 4 0
104 R Kovac Croatia 3.5 0
114 Jensen Denmark 3 0
132 Worns Germany 4 0
226 Vieira France 6 0
202 Petrov Bulgaria 3 0
250 Astaf Latvia 2.5 0
321 Henry France 8.5 0
345 Postiga Portugal 3.5 0
335 Nistroo Holland 8 0
Total 50 10

The idea being that my league table would end up looking something like
this.

Pos Manager Pts
1 Tony 69
2 Chris 50

Very grateful for any ideas or code on how to put this together.

Tony