Create an array-type in Excel dynamically using cells references and/or constant values.

 

NxArray(Arg1, Arg2, Arg3, ...)

Arg1 is the first element in the array (i.e. a single-cell reference or a constant value).

Arg2 is the second element in the array (i.e. a single-cell reference or a constant value).

Arg3 is the third element in the array (i.e. a single-cell reference or a constant value).

1. NxArray function accepts up to 25 arguments.
2. NxArray function returns a single-column array. For a row-based array, use NxTranspose function.
3. NxArray function maintains the order in the array as they appears in the arguments list.
4. The Length of the output array is determined by the last argument with non-missing value. Intermediate argument(s) with missing values are represented as #N/A in the output array.
5. With the exception of the 1st argument (arg1), remaining arguments are optional and can be missing.
6. The NxFold() function is available starting with version 1.66 PARSON.

• 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

• What to do About Missing Values in Time Series Cross-Section Data , James Honaker and Gary King, American Journal of Political Science