The example I pointed you to has 20 teams in a single league - in the
World Cup there are usually 8 leagues of 4 teams, so I thought you
could cut the example down to 4 teams and then just replicate it 7
more times. That would give you the initial group stages, but the
tournament then goes into a knockout phase, so a different approach
would be needed for that.

Whenever the World Cup (or European Championship) is on, there are
usually templates printed in newspapers showing all the games
scheduled, so I would suggest that you base your worksheet(s) on one
of those.

If you take the Rugby World Cup, currently on in France, there are 4
leagues with about 6 teams in each league for the initial stages, so
you might want to be a bit more flexible in your design to cope with
situations like that.

Hope this helps.

Pete

On Sep 24, 6:36 pm, shagil wrote:
We call the game 'football' also in this part of the world where i live but i
used "soccer" (stupid as it sounds) in order to prevent any confusion.
anyway thank you for replying.
i did try the template you mentioned but it is not axactly what i need.
I was thinking of the all famous world cup score chart where i would have
the tournament game schedule with a table (group rankings) on the right side
. as soon as the match scores have been entered, ranking must update
automatically with the team with most points in the 1st row of the ranking. I
can mail what i hve done with the excel sheet if need be. I hope i am making
sense.



"Pete_UK" wrote:
I used to call it soccer when I was a kid, many years ago - some of my
friends thought football meant Rugby Football !! <bg

Pete

On Sep 23, 1:07 am, "Peo Sjoblom" wrote:
I never thought I'd see the day when someone with UK in his name would call
football soccer :)

--

Regards,

Peo Sjoblom

"Pete_UK" wrote in message

oups.com...

Although much larger than your application, have a look here for a
working example of a soccer league:

http://www.xldynamic.com/source/xld.LeagueTable.html

This should give you some ideas.

Hope this helps.

Pete

On Sep 22, 9:58 am, shagil wrote:
i have 4 teams. we play a league (three rounds). the bottom on the
ranking is
eliminated and will not make it to the semi final. Inthe semi final, team
with the highest in rank plays the second highest. Winner goes to the
final,
Looser plays the secon semi final match with the third team in rank. so
the
winner in this match goes to the final as the second finalist. Winner in
this
match gets th cup. I tried to use the =VLOOKUP($--,$--$--$--,--,FALSE)
for
automatic rank but its not working. any help is appreciated. thanks- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -