This is another way to deal with SC’s descending order spreadsheet studies, different from using the INDEX(…MATCH…)) function combination.
It is an expansion of the concept in SC’s documentation, without having to manually enter a formula in every cell: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetAdditionalInfo.html#ReversingChartOrder 1) Put this in cell Z3: =$J$30-ROW()+3 2) Put this in cell Y3: =INDEX(A$3:A1002,Z3,1) This assumes you have Number of Rows set to 1000. Edit the A1002 to the number of rows +2. This example sorts the Date Time column A, but it works with any column. |