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.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
