Results 1 to 4 of 4

Help with functions in a Bowl Pick Ems

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2010
    Location
    Oklahoma
    MS-Off Ver
    Excel 2007
    Posts
    22

    Help with functions in a Bowl Pick Ems

    I am doing a Bowl Pick Ems Sheet for me and my friends. I have everything set up except on the updated standings tab. On the left side of the updated standings sheet it looks like this:

    A B C
    Points Player Current Order
    4 Paul 1
    2 Tony 8
    3 Chase 3
    1 Chris 11
    4 Austin 1

    which sums up the total points in column A, the name in column B and using the rank function places them in a current order in column C.

    Now, on the right side:

    K L S
    Rank Updated Standings Total Points
    1 Paul 4
    2 Chase 3
    3 Tony 2
    4 Chris 1
    5 #NUM #NUM
    6 Paul 4

    and then repeats 1-4 as it goes down to the 14 people. Now, on the left side with the total points, player and current order everything works great.

    My questions are this:

    How do I keep column K (Rank) up to date with the current order in column C?
    How do I keep the Total Points up to date to match up with column A in descending order including potential ties?
    After that, can't I just use VLOOKUP to match the column L (name) with the (total points) in column S as I am currently doing?

    I would really appreciate any help you guys could give, thanks in advance!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1