Van_Nistelblore
New Member
- Joined
- Mar 18, 2002
- Messages
- 1
Last week I posted a message saying that for my iCT coursework I have to do something where I can get a league table to automatically update by typing in my football league's results. I was told to research RANK, VLOOKUP and IF but I'm still no clearer.
Here is the table.
Pos. Teamn P W D L F A Gd Pt
1 Beighton 15 14 1 0 82 23 59 43
2 Greasbrough 14 12 0 2 67 25 42 36
2 Crosspool 16 11 3 2 52 36 16 36
4 Porter 15 9 2 4 44 29 15 29
5 Holly Bush 13 6 1 6 41 36 5 19
6 Ecclesall 14 4 6 4 37 37 0 18
7 Harthill 14 5 2 7 37 43 -6 17
7 Harthill Dyn 17 5 2 10 56 67-11 17
9 Tickhill 17 5 0 12 40 65-25 15
10 Rose House 15 4 1 10 39 53-14 13
11 Penistone 14 2 3 9 31 46-15 9
11 Monk Bretton 18 2 3 13 29 95-66 9
That is my Sunday league side's league table, I play for Greasbrough. Anyway, any help in idiot terms would go a long way for me. HOW DO I GET THE TABLE TO UPDATE ITSELF BY TYPING THE RESULTS IN! Please help. Ive got 4 weeks to design the system and all the documentation for the coursework.
Here is the table.
Pos. Teamn P W D L F A Gd Pt
1 Beighton 15 14 1 0 82 23 59 43
2 Greasbrough 14 12 0 2 67 25 42 36
2 Crosspool 16 11 3 2 52 36 16 36
4 Porter 15 9 2 4 44 29 15 29
5 Holly Bush 13 6 1 6 41 36 5 19
6 Ecclesall 14 4 6 4 37 37 0 18
7 Harthill 14 5 2 7 37 43 -6 17
7 Harthill Dyn 17 5 2 10 56 67-11 17
9 Tickhill 17 5 0 12 40 65-25 15
10 Rose House 15 4 1 10 39 53-14 13
11 Penistone 14 2 3 9 31 46-15 9
11 Monk Bretton 18 2 3 13 29 95-66 9
That is my Sunday league side's league table, I play for Greasbrough. Anyway, any help in idiot terms would go a long way for me. HOW DO I GET THE TABLE TO UPDATE ITSELF BY TYPING THE RESULTS IN! Please help. Ive got 4 weeks to design the system and all the documentation for the coursework.