Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I'm not an experienced user of excel but want to create a worksheet sheet to work in a tournament format with picture, have two picture next to each other click on one and it moves it to the next round. I have around 20 pictures of teams and which need to gradually reduce to a winner in the final. Can anyone help? Is there a template to get hold of. Thought someone will have already done some thing like this for football teams? -- Jarvis ------------------------------------------------------------------------ Jarvis's Profile: http://www.excelforum.com/member.php...o&userid=25258 View this thread: http://www.excelforum.com/showthread...hreadid=387503 |
#2
![]() |
|||
|
|||
![]()
Hi Jarvis. If you're not real experienced with Excel you might want to
consider another method. You could build your own "Tournament Tree" in Excel by using Format - Borders, and typing into the cells the name of each team. This will show the progression thru the tournament. I built a tree for a 20-team, single elimination tournament. It looks to me like one team will have to get a by. HTH -- Sincerely, Michael Colvin "Jarvis" wrote: I'm not an experienced user of excel but want to create a worksheet sheet to work in a tournament format with picture, have two picture next to each other click on one and it moves it to the next round. I have around 20 pictures of teams and which need to gradually reduce to a winner in the final. Can anyone help? Is there a template to get hold of. Thought someone will have already done some thing like this for football teams? -- Jarvis ------------------------------------------------------------------------ Jarvis's Profile: http://www.excelforum.com/member.php...o&userid=25258 View this thread: http://www.excelforum.com/showthread...hreadid=387503 |
#3
![]() |
|||
|
|||
![]()
Hello Jarvis. Just divided the 20 teams on group of 5. Given the to team a
bye. The winner of 19 and 20 play 1 the winner of 17 and 18 play 2, winner of 14 and 16 play 3 and winner of 12 and 13 play 4. "Michael" wrote: Hi Jarvis. If you're not real experienced with Excel you might want to consider another method. You could build your own "Tournament Tree" in Excel by using Format - Borders, and typing into the cells the name of each team. This will show the progression thru the tournament. I built a tree for a 20-team, single elimination tournament. It looks to me like one team will have to get a by. HTH -- Sincerely, Michael Colvin "Jarvis" wrote: I'm not an experienced user of excel but want to create a worksheet sheet to work in a tournament format with picture, have two picture next to each other click on one and it moves it to the next round. I have around 20 pictures of teams and which need to gradually reduce to a winner in the final. Can anyone help? Is there a template to get hold of. Thought someone will have already done some thing like this for football teams? -- Jarvis ------------------------------------------------------------------------ Jarvis's Profile: http://www.excelforum.com/member.php...o&userid=25258 View this thread: http://www.excelforum.com/showthread...hreadid=387503 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |