Your image shows 10 columns of data - Columns A - J.
Presuming your main sheet is named Data, in your second sheet, in Cell A1, enter the formula:
=SORT("Data"!A:J, 5, -1) to sort the data in Columns A - J by the 5th column ('Final') in descending order (highest to lowest values).
If you want to sort by the 'Speed' Column, change the 5 above to 6. Etc ...
If your main sheet is named something other than "Data" (e.g. "Sheet1") then change the part of the above formula from "Data" to "your sheet name". (Use the "double-quote" characters if your sheet-name has any spaces in it, otherwise you don't actually need the "double-quote" characters.)
When you enter the above formula, the original data will appear on your 2nd sheet sorted by the column order which you chose, in descending numerical order (highest to lowest).
Good luck, good skill!
Ted
__________________
RDSS - Racing Decision Support System™ "The Modern Sartin Methodology" . . . . www.rdss2.com
|