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

Create an array-type in Excel dynamically using cells 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. 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.

Files Examples

References

External Links

Have more questions? Submit a request

0 Comments