NxSubset - Time Series Subset

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

  1. The input data set may include empty and missing values.
  2. The input data set may span multiple rows and/or columns, but the results is always one-dimensional array (i.e. column).
  3. 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

Have more questions? Submit a request

0 Comments