Hi, I,m trying to write a formula to help speed up results at motorsport events we run. Column A- would have the car numbers, B- the drivers name, C-make of the car, D- score for run one, E- score for run two, F- for run three, and G- Highest score from D-E-F.
What I'm trying to achive is, as each car does its first run its score is input into column (D) when it does its second run its score is input into column (E) third run column (F) then a formula picks the highest of that cars three scores and automatically inputs it into column (G) I need to find a way to lock the horizontal column so the car number, Driver, car make and its scores all stay together, and the higest score from column (G) moves to the top of the list. So if car number 5 had the highest score. he would automatically move to the top of the list, if car 7 had the second highest, he would move to second on the list and so on. Is what I'm trying to do possible? Thanks in advance for any help recieved,
Regards,
Kieran Hynes.