Results 1 to 6 of 6

creating a formula to sort names from one column's results and sort them based on another

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    365
    Posts
    63

    creating a formula to sort names from one column's results and sort them based on another

    I am looking to create a self populating ladder to be used for a race.

    The racers will go through a time trial process to determine their seeding for the heats and they will be broken down to 2 separate heats of 4. The racers will race in the heat of 4 and the top 2 from each of the first heats will move on to the Final.

    So bellow is a sample of what the ladder will look like. Column B will give the racers Time Trial ranking which will determine the order the racers will be placed in the ladder. Column C is the racers name. Column D will be the result of the athletes heat 1 and heat 2. the top two riders from each heat move towards the final. so from heat 1 (Racer 1, and Racer 2) and heat 2 (Racer 6, and Racer 7) will move forward to the finals. And in column F will be where they will move too, the actual order of the list for Finals which is based on the riders TT results. So the order for finals will be....

    1st - Racer 1
    2nd - Racer 6
    3rd - Racer 2
    4th - Racer 7

    What I am looking to do is create a formula that will self fill Column F when I manually fill out the ranking in Column D (in Red). So it needs to sort column F and only select the top 2 from heat 1 and 2. Then look at the four racers TT rank and put them in the proper order in the Finals based on TT.

    Thanks
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort Rows and copy sort results to new worksheet?
    By Apache_sim in forum Excel General
    Replies: 0
    Last Post: 06-30-2015, 03:17 AM
  2. [SOLVED] I have a sort macro. How to add script to preselect rows to sort based on column value?
    By Jasonhouse in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-09-2014, 02:25 AM
  3. sort entire row based on formula result in Column D
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2013, 12:59 AM
  4. Need help creating a formula that will sort and populate based off certain selections
    By stephanieisanerd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2013, 05:37 PM
  5. Replies: 4
    Last Post: 03-14-2013, 09:14 PM
  6. Replies: 4
    Last Post: 11-20-2012, 06:00 PM
  7. Replies: 5
    Last Post: 01-13-2012, 03:20 PM

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