Spreadsheet.RankVariables

This function ranks the specified range of variables in the spreadsheet.

Syntax Parameters Return Value 
Sub Spreadsheet.RankVariables( _
    Variables As Variant, _
    Optional Rank1 As RankAssignment = scRankSmallest, _
    Optional Ties As RankTieResolution = scRankMean, _
    Optional Type As RankType = scRankRegular, _
    Optional selectionIncludeExpression As String = "", _
    Optional selectionIncludeList As String = "", _
    Optional selectionExcludeExpression As String = "", _
    Optional selectionExcludeList As String = "", _
    Optional weightVar As Integer = 0)
  • Variables [in]

Which variables to rank.

Type: Variant

  • Rank1 [in,optional]

Integer value specify the rank assignment: scRankSmallest, scRankLargest.

Type: RankAssignment

Default value: scRankSmallest

  • Ties [in,optional]

The rank tie: scRankHigh, scRankLow, scRankMean, scRankSequential.

Type: RankTieResolution

Default value: scRankMean

  • Type [in,optional]

Integer value specifying rank type: scRankFractionalPercent, scRankFractional, scRankRegular.

Type: RankType

Default value: scRankRegular

  • selectionIncludeExpression [in,optional]

The selection inclusion expression.

Type: String

Default value: ""

  • selectionIncludeList [in,optional]

The selection inclusion list.

Type: String

Default value: ""

  • selectionExcludeExpression [in,optional]

The selection exclusion expression.

Type: String

Default value: ""

  • selectionExcludeList [in,optional]

The selection exclusion list.

Type: String

Default value: ""

  • weightVar [in,optional]

The weight variable.

Type: Integer

Default value: 0

This function does not return a value.