Soccer Help

[Sheepkin_Coat]

I want to make a little game for my son...

I have a list of teams that i want excel to pick to play against each other and then when i have entered the scores the winners go into the next round and so on till the final. can this be done

[VBA Noob]

Could you adapt this

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

VBA Noob

[svaiskau]

If your teams are in column A, and their first round scores in column B, you just want the formulas to be:

=IF(B1 > B2, B1, B2)
=IF(B3 > B4, B3, B4)

etc for the second round, and so forth for subsequent rounds.

The way you format it is up to you.

EDIT: Guess I didn't read OP very well. I would go with VBA Noob's advice.

[Sheepkin_Coat]

here is what i want

NK Dinamo Zagreb - The New Saints NK Dinamo Zagreb (CRO)
- IF Elfsborg (SWE)
- MSK Zilina (SVK)
- APOEL FC (CYP)
- Domzale (SVN)
- FK Sarajevo (BIH)
- Tampere United (FIN)
- The New Saints (WAL)

|make draw|

There are 28 teams in the first round