NxArray - Create an array using constants and/or cells references

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

Syntax

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).

Remarks

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

Files Examples

Related Links

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

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.