A B C D E F G
CAR NO. RUN 1 RUN 2 RUN 3 TOTAL QUALIFIER
5 6 4 3 13
CAR NO 2
2 4 6 7 17
This is a qualifying sheet we are making up for a motorsport event we run, in the knockout rounds two cars go head to head over three runs, the car with the highest score after the three runs progresses to the next round. In column B we input the car numbers, in columns C. D. and E we input their scores, column F is an autosum of C.D.E. in column G. I want to show the winning cars number, not its score, anyone got any ideas? Thanks in advance,
Kieran.
PS. this is part of a larger spreadsheet with which I've recieved much help from this forum, I can make this available if anyone's intrested, if I can figure out how to post it on this forum, The spreadsheet is for DRIFTING and it automatically picks the top 16, sets up the knockouts, final 16, final 8, final 4, final 2, and the winner.
(The grid I did above went daft when I posted it, I did another on the attachment.)