MAKEARRAY Function Explained
The MAKEARRAY function in Microsoft Excel creates an array from a given set of values. It takes up to 254 values as arguments and returns an array with the same number of elements as the number of arguments. The array can be used in other formulas and functions.
MAKEARRAY Function Syntax
MAKEARRAY(value1, value2, ...)
- value1: The first value to be included in the array.
- value2: The second value to be included in the array.
- …: Additional values to be included in the array.