Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board


View Single Post
Old 02-01-2023, 11:32 PM   #6
Ted Craven
Registered User
 
Ted Craven's Avatar
 
Join Date: Aug 2007
Location: Nanaimo, British Columbia, Canada
Posts: 978
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



Ted Craven is offline   Reply With Quote Reply
 
» Advertisement
» Current Polls
Wh deserves to be the favorite? (last 4 figures)
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 07:27 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.