+ Reply to Thread
Results 1 to 2 of 2

Assigning points to positions and automatically reordering positions based off points

  1. #1
    Registered User
    Join Date
    03-11-2019
    Location
    Indiana
    MS-Off Ver
    Google Docs
    Posts
    1

    Assigning points to positions and automatically reordering positions based off points

    Hello all. I took an excel class in high school but took a separate life course, however i started an online racing series where the points are as follows. 1=26, 2=23, 3=21, 4=19 and from 4th to 24th the points are decreased by one so 5th would be 18 and 6th would be 17 and so on. The problem Im having is I want to be able to enter the riders position in the round column (spreadsheet link isnt allowed to be posted but I can email it to anyone who will help) for each round they complete and points be assigned based off that position and then then, based off the points, automatically reorder the riders list based of points totals. I know this is alot to ask and if you can help that would be awesome! Ive fought it for a week now and im stumped. Thanks!

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,419

    Re: Assigning points to positions and automatically reordering positions based off points

    A
    B
    C
    D
    E
    F
    G
    1
    Rider
    Round1
    Round2
    Round3
    Round4
    Total
    2
    Alan
    3
    18
    11
    19
    42
    F2: =23 * COLUMNS(B2:E2) - SUM(B2:E2) + SUMPRODUCT(LOOKUP(B2:E2, {1,2,3,4}, {4,2,1,0}))
    3
    Barb
    8
    5
    18
    6
    55
    4
    Cain
    10
    8
    21
    12
    41
    5
    Dana
    9
    6
    13
    3
    62
    6
    Eric
    17
    19
    9
    17
    30
    7
    Fran
    11
    7
    15
    8
    51
    8
    Gary
    16
    16
    16
    10
    34
    9
    Hana
    19
    22
    5
    2
    46
    10
    Ivan
    21
    11
    1
    20
    43
    11
    Jane
    18
    4
    4
    14
    52
    12
    Kent
    12
    2
    20
    16
    44
    13
    Leah
    14
    14
    19
    22
    23
    14
    Mark
    22
    20
    7
    13
    30
    15
    Nina
    4
    1
    6
    4
    81
    16
    Otto
    5
    17
    12
    1
    61
    17
    Peri
    13
    10
    2
    5
    64
    18
    Quin
    20
    13
    22
    18
    19
    19
    Rene
    1
    21
    17
    7
    50
    20
    Seth
    2
    15
    14
    9
    54
    21
    Tina
    6
    3
    3
    21
    61
    22
    Ulis
    15
    9
    8
    11
    49
    23
    Vera
    7
    12
    10
    15
    48


    Sort by the Total column.
    Last edited by shg; 03-11-2019 at 11:55 AM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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