SortSeriesDual

Top  Previous  Next

Sorts the series1 based on the values in series2. Only for non auto indexed series. Not available for auto indexed series.

 

Note that the three optional parameters are only optional if the preceding parameter is included.

The following are valid:

 

SortSeriesDual( series1, series2 )

SortSeriesDual( series1, series2, elementCount )

SortSeriesDual( series1, series2, elementCount, offset )

SortSeriesDual( series1, series2, elementCount, offset, direction )

 

The following is not valid:

 

SortSeriesDual( series1, series2, direction )

 

 

Syntax

 

SortSeriesDual( series1, series2, [element count], [offset], [direction] )

 

Parameters

series1

 

Series 1, that will be sorted

series2

 

Series 2, to use for the sorting

element count

 

the number of elements to sort. Default is series element count.

offset

 

the starting index from which element count goes back for non auto indexed series. Default is series element count.

direction

 

positive number sorts ascending, negative number sorts descending. Default is ascending sort.

returns

 

n/a

 

Example

 

 

         ' Sort resultsIndex based on the values of the results series.

         SortSeriesDual( resultsIndex, results, elementsToSort, elementsToSort, -1 )

         

         ' Now sort the results series.

         SortSeries( results, elementsToSort, elementsToSort, -1 )