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] )

 

Parameter:

Description:

series1

The series name that will be sorted based upon the values in series2.

series2

The series name that contains the values sorting will use to determine the sort

[element count]

Optional value.  Function default sorting action is to sort all the elements in the series.  When a value is entered, that value determines how many elements in the series are sorted.

[offset]

Optional value. The starting index from which element count goes back for non auto indexed series.  Default value is zero so the function will sort the [element count] specified elements.

[direction]

When parameter is not used, the default sort is in ascending order.

Note:

Positive value sorts the elements in ascending order.

Negative value sorts the elements in descending order.

 

Example:

'  Sort resultsIndex based on the values of the results series.
SortSeriesDual( resultsIndex, results, elementsToSort, elementsToSort, -1 )
     
'  Sort the series element in descending order.
SortSeries( results, elementsToSort, elementsToSort, -1 )

Returns:

Sorted series based upon the values in the series 2.

 

Links:

SortSeries

See Also:

Series Function

 


Edit Time: 9/25/2017 09:09:58 AM


Topic ID#: 572

 

Created with Help & Manual 7 and styled with Premium Pack Version 2.80 © by EC Software