Hey guys
Thought someone here may be able to help me with a little spreadsheet i'm writing for Drift Comps to speed up the process of working out who came where. Basically, it automatically works out the final order of the drivers based on where they got knocked out and by who.
Now, my problem is getting the drivers to show up in order. I'll put forward the scenario that troubles me. After qualifying, 1st v's 16th, 2nd v's 15th, 3rd v's 14th, ect so that gives the higher pointscorers from the heats the best chance to progress to the top 4. Now, if 1st KO's 16th, 16th stays in 16th place as he was the lowest point scorer before the finals. If by chance, 16th KO's 1st, 1st doesn't drop to 16th, he goes to 9th as thats the highest placing you can get outside the top 8. How do i get them to go in correct order? I can email someone the excel file if they like so they can play with it. I hope someone understands this lol.