Excel MAKEARRAY Function (365)

Description

The Excel MAKEARRAY function returns a calculated array based on the given number of rows and columns.

Formula syntax

Arguments

Returns

The MAKEARRAY function returns an array.

Errors

1. When an invalid LAMBDA function or an incorrect number of parameters is provided, it returns #VALUE error called “Incorrect Parameters”.

2. When any one of the arguments rows and columns is smaller than 1 or not integer or a nonnumeric value, it returns #VALUE! error.

Version

Excel 365

Usage and Examples

Example 1 to create an array with 2 rows and 3 columns and fill the result with multiplying rows and columns

Select a cell then use the formula:

=MAKEARRAY(2,3,LAMBDA(r,c,r*c))

Press Enter key, and a 2-D table is created.

Example 2 to create an array with 2 rows and 3 columns and fill the result with the text "KTE"/strong>

Select a cell then use the formula:

=MAKEARRAY(2,3,LAMBDA(r,c,"KTE"))

Press Enter key, and a 2-D table is created.

Example 3 to create an array with 3 rows and 1 column and fill random numbers between 1-10

Select a cell then use the formula:

=MAKEARRAY(3,1,LAMBDA(r,c,RANDBETWEEN(1,10)))

Press Enter key, and a single-column table is created.

Other Functions:

• Excel BYCOL Function
  The Excel BYCOL function applies a LAMBDA function to each column in a given array and returns the result per column as a single array.

• Excel BYROWsan> Function
  The Excel BYROW function applies a LAMBDA function to each row in a given array and returns the result per row as a single array.

• Excel LAMBDA Function
  The Excel LAMBDA function is used to create custom functions that can be reused throughout a workbook.

• Excel F.DIST Function
  The Excel F.DIST function returns the F probability distribution which is usually used to measure the degree of diversity between two data sets.