Results 1 to 3 of 3

Thread: MS Excel Help

  1. #1
    Hardcore Til I Die htid's Avatar
    Join Date
    Mar 2006
    Location
    London
    Posts
    1,802
    Thanks
    81
    Thanked
    32 times in 22 posts
    • htid's system
      • Motherboard:
      • Asus P5B
      • CPU:
      • C2D E6600 @ 3ghz
      • Memory:
      • 2gb Corsair XMS2
      • Storage:
      • 180gb Spinpoint
      • Graphics card(s):
      • XFX 7900GTX
      • PSU:
      • 500W Seasonic S12
      • Case:
      • Akasa Mirage
      • Monitor(s):
      • 18" Dell

    MS Excel Help

    Hi, don't know if anyone here can help with this..but!

    Basically my housemate is president of the ten pin bowling club at uni and he wants to make a spreadsheet to calculate scores.

    It will work as an F1 style league table, best score on the day gets 10, 2nd gets 9 etc down to 0. Each player has a handicap so what basically needs to happen is this:

    He has a column with each persons handicap, he has a column of the weeks score, He wants to be able to type each persons score into the correct box, and then have excel add the handicap to that score, find the 10 highest scores and allocate the appropriate points to another column.

    Is this possible? If so could someone by any chance write out the forumula for that? *angelic face*

    Cheers
    Chris.

  2. #2
    Hardcore Til I Die htid's Avatar
    Join Date
    Mar 2006
    Location
    London
    Posts
    1,802
    Thanks
    81
    Thanked
    32 times in 22 posts
    • htid's system
      • Motherboard:
      • Asus P5B
      • CPU:
      • C2D E6600 @ 3ghz
      • Memory:
      • 2gb Corsair XMS2
      • Storage:
      • 180gb Spinpoint
      • Graphics card(s):
      • XFX 7900GTX
      • PSU:
      • 500W Seasonic S12
      • Case:
      • Akasa Mirage
      • Monitor(s):
      • 18" Dell
    bump

    ...nobody knows?

  3. #3
    Member
    Join Date
    Aug 2005
    Location
    Reading, UK
    Posts
    74
    Thanks
    0
    Thanked
    0 times in 0 posts
    Chris,

    First part is something like this:-

    =VLOOKUP(F2,$A$2:$B$12,2,FALSE)+G2

    This will return the score+handicap.

    F2 = cell reference of the name of the person who played today
    $A$2:$B$12 = The list of names and handicaps
    2 = Return handicap value (2nd column, 1st = name)
    FALSE = List of names does not need to be in order
    G2 = today's score

    You would then copy of formula down for each person played today.

    My data looks like this:-

    A____B_______F____G____H
    Name Handicap Name Score Total

    Sorting is a bit more interesting, but don't have a sheet to hand, but I'll post later with the steps.

    Matt

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel windows
    By Steve in forum Software
    Replies: 4
    Last Post: 25-07-2006, 12:44 PM
  2. M$ Excel masters..
    By XA04 in forum Help! Quick Relief From Tech Headaches
    Replies: 9
    Last Post: 19-09-2005, 10:48 AM
  3. Replies: 6
    Last Post: 12-08-2005, 08:50 AM
  4. Excel spreadsheet fixing tool?
    By joshwa in forum Software
    Replies: 2
    Last Post: 28-10-2004, 11:23 AM
  5. Excel - Office XP
    By KDH in forum Software
    Replies: 0
    Last Post: 04-08-2004, 11:08 PM

Posting Permissions

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