Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 19th 06, 01:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 1
Default making a fixture list

Hi there, i am doing a competition between friends, which consist of
predicting the F.A premiership results in britain. Is there a way to
make a list in excel so when i e mail it all they have to do is put
their predictions in the box and send it back to me, please help


  #2   Report Post  
Old September 19th 06, 01:58 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default making a fixture list

Are they predicting the complete set of fixtures or just one week's?

The best way of setting up a complete fixture list is to have the teams
listed alphabetically in column A, starting in A2 and then to transpose
the same list into the columns from B1, so that you would have
something like:

Arsenal Aston Villa Blackburn etc
Arsenal x
Aston Villa x
Blackburn x
etc

The team in column A is the home team - those on row 1 are the away
teams. Obviously a team cannot play itself, so there is no entry in
cells B2, C3, D4 etc (shown as x above). The cells at the intersections
of the teams can be used to record the date the fixture is planned, or
the score if the game has been played, or the attendance etc. - a very
flexible table.

Hope this helps.

Pete


wrote:
Hi there, i am doing a competition between friends, which consist of
predicting the F.A premiership results in britain. Is there a way to
make a list in excel so when i e mail it all they have to do is put
their predictions in the box and send it back to me, please help




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
Making a dynamic list?! mayerc Excel Discussion (Misc queries) 2 June 15th 06 03:47 PM
making a list ?¿ Brian Brandt Excel Worksheet Functions 0 April 25th 06 02:41 PM
Making words in a list a value!! brco1 Excel Discussion (Misc queries) 2 September 26th 05 11:18 PM
Making list of items to truck monthly usage Yarek Excel Discussion (Misc queries) 0 June 23rd 05 10:37 AM
making used values fall from a list static69 Excel Discussion (Misc queries) 4 February 17th 05 03:04 AM


All times are GMT +1. The time now is 08:55 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017