Still stuck!
Still stuck!
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Still stuck!

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've built a nifty score-standings management tool for both my spring football (American football, that is) league and for tracking the NFL; it requires manual entering of scores, but after that everything else is automated with VLOOKUPs and other fun stuff - I don't use RANK, however. If your assignment requires using RANK, that's something we'll have to build into it.

    If you'd like to see the tool, email me and I'll send it to you. We can go forward if you think it looks like it's doing something like what you want.

    [ This Message was edited by: Duane on 2002-03-19 12:47 ]

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Van N,

    I don't think I *told* you to, I believe I suggested you research them... I also suggested my premiership league table which does exactly what you want using those single 3 functions ! It's still here if you want it


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com