Returns the subset of an array of cells.
Syntax
NxSubset(X, start, finish, keepNA)
X is the input data set (a one dimensional array of cells (e.g. rows or columns)).
start is the first element index in X. If missing, start=1.
finish is the last element index in Y. If missing, end = last element in X.
keepNA is a flag for leaving (or purging) observations with missing values (e.g. #N/A, #VALUE!, #NUM!, empty cell) found in the input data set. If missing, keepNA=False.
Remarks
- The input data set may include empty and missing values.
- The input data set may span multiple rows and/or columns, but the results is always one-dimensional array (i.e. column).
- If KeepNA is set to False (0), observations with missing values (e.g. #N/A, #VALUE!, #NUM!, empty cell) in the input data set are purged prior to selecting the subset.
Files Examples
References
- Hamilton, J .D.; Time Series Analysis , Princeton University Press (1994), ISBN 0-691-04289-6
- Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740