Any Excel experts out there that can help me with a function/formula, that will assign winners based upon highest scores?
I am preparing for a Pinewood Derby for the young boys at church. I've put together a race schedule where each boy will get to race his car 6 times - 2 times on each of the 3 tracks. From each heat, the 1st place car will get 3 points, 2nd place gets 2 points, and 3rd place gets 1 point.
The scoring spreadsheet that I've put together has a row that will tally and display each car's total score. I would like a formula that will take the results of that column, and assign 1st place to the highest score, 2nd place to the next highest, etc. Anyone recommend what function I want to use?
I am preparing for a Pinewood Derby for the young boys at church. I've put together a race schedule where each boy will get to race his car 6 times - 2 times on each of the 3 tracks. From each heat, the 1st place car will get 3 points, 2nd place gets 2 points, and 3rd place gets 1 point.
The scoring spreadsheet that I've put together has a row that will tally and display each car's total score. I would like a formula that will take the results of that column, and assign 1st place to the highest score, 2nd place to the next highest, etc. Anyone recommend what function I want to use?