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

ups.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 -