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