Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jarvis
 
Posts: n/a
Default How to CreateTournament Worksheet


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   Report Post  
Michael
 
Posts: n/a
Default

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   Report Post  
Rafael
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"