Saturday, October 22, 2011

yogi_Sort A Range By A Specified Column In Specified Order

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user alter73 said:
there is another question - is there a way that columns E and F are at once sorted by total time?. I want the best result (player and his total time) to be always the first one in a row 2. Of course I can use a list version of the spreadsheet and to manually sort the results by total time, but I want this sorted version to be permanent to publish it in this exact version. Is it possible?
following is one solution to the problem