How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,831
- Office Version
- 2010
- Platform
- Windows
Football Fixtures…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Hi, I’m trying to re-build my workbook…My previous efforts haven’t had a fixture list. I’ve been putting the fixtures into my workbooks on a weekly basis and then entering the results.
<o> </o>
I now have an interim workbook with the season’s fixtures in.
<o> </o>
So using Data Validation I select a week number (C4 in the Jeanie below) and my games appear as in my Jeanie…
<o> </o>
My question is, how will I manage this when there are midweek games that have previously been postponed? i.e. there could be a game from week 1, week 6 and week 7.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Hi, I’m trying to re-build my workbook…My previous efforts haven’t had a fixture list. I’ve been putting the fixtures into my workbooks on a weekly basis and then entering the results.
<o> </o>
I now have an interim workbook with the season’s fixtures in.
<o> </o>
So using Data Validation I select a week number (C4 in the Jeanie below) and my games appear as in my Jeanie…
<o> </o>
My question is, how will I manage this when there are midweek games that have previously been postponed? i.e. there could be a game from week 1, week 6 and week 7.
Excel Workbook | ||||||
---|---|---|---|---|---|---|
C | D | E | F | |||
4 | 13 | Home | Away | |||
5 | 1 | Zenit St Petersburg | V | FK Rostov-Na-Donu | ||
6 | ||||||
7 | 2 | FK Rubin Kazan | V | Dinamo Moscow | ||
8 | ||||||
9 | 3 | Krasnodar | V | Volga | ||
10 | ||||||
11 | 4 | PFK Samara Kryliya | V | Kuban Krasnodar | ||
12 | ||||||
13 | 5 | CSKA Moscow | V | Anzhi Makhachkala | ||
14 | ||||||
15 | E | FK Amkar Perm' | V | Terek Grozny | ||
16 | ||||||
17 | 7 | Lokomotiv Moscow | V | Spartak Nalchik | ||
18 | ||||||
19 | 8 | FK Tom' Tomsk | V | Spartak Moscow | ||
Sheet1 |