# Assigning points to positions and automatically reordering positions based off points

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. ## 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.

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

#### 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