 |
 |
|
 |
 |
|
 |
 |
 |
Description: Returns the rank value (i.e., the unreliability estimate from rank regression) and associated time values for the specified row. Use numbers to identify both the row and column (e.g., to retrieve the calculated rank value for the second row, enter 2 for the row and 1 for the column).
Syntax: DATARANK(Data_Src, Row, Column)
Data_Src is the source data sheet from which the value is taken.
Row is the row number in the data sheet.
Column is a numerical value that specifies which value to calculate for.
Remarks:
The Data_Src can be one of the following values:
A default data source selected from the Data Source Index drop-down list.
A data sheet name (e.g., "Folio1!Data 1").
A variable name defined in the Defined Names window (e.g., datasource).
The Row value must 0 or higher.
If it is 0, it returns the string corresponding to the Title (Header Text) that will be returned for values in that column.
In such cases, the Col value can be either 1 or 2 for data sheets without interval data, or 1, 2, 3 or 4 for datasheets with interval data.
Column is a numerical value that specifies which value to calculate for.
If it is -1, it returns the number of failures in the datasheet.
If it is 0, it returns the empty string.
If it is 1, it returns the rank value for the specified cell.
If it is 2, 3 or 4, it returns the value specified by the Row option.
Example:
DATARANK("Folio1!Data 1", 1, 1)
© 1992-2019. HBM Prenscia Inc. ALL RIGHTS RESERVED.
 |
E-mail Link |