MAKEARRAY

Formulas / MAKEARRAY
Create an array with calculated values.
=MAKEARRAY(rows, columns, lambda)
  • rows - required, number of rows in the data set
  • columns - required, number of columns to be returned
  • lambda - required, custom LAMBDA calculation

Examples

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

    The MAKEARRAY function can be used to generate a 2x3 array of numbers. In this example, we will use the formula to generate an array of numbers. This formula multiplies the row and column numbers of each cell to generate the value for the cell. The result of this formula is {1,2,3;2,4,6}. This array contains six cells with values of 1, 2, 3, 4, 5, and 6.

  • =MAKEARRAY(2,3,LAMBDA(r,c,0))

    The MAKEARRAY function can also be used to generate a 2x3 array of zeroes. In this example, we will use the formula to generate an array of zeroes. This formula sets the value of each cell to 0. The result of this formula is {0,0,0;0,0,0}. This array contains six cells with values of 0.

  • =MAKEARRAY(2,3,LAMBDA(r,c,"x"))

    The MAKEARRAY function can also be used to generate a 2x3 array of characters. In this example, we will use the formula to generate an array of characters. This formula sets the value of each cell to "x". The result of this formula is {"x","x","x";"x","x","x"}. This array contains six cells with values of "x".


Summary

The MAKEARRAY function allows users to create an array with custom rows and columns using a LAMBDA calculation. It is possible to create arrays with variable dimensions and the values in the array will be calculated.

  • The MAKEARRAY function creates a calculated array of a specified row and column size. It takes three arguments: rows, cols, and lambda. Both the row and col arguments are required, and the lambda argument is required and must be a LAMBDA that creates the array.

Frequently Asked Questions

What is the MAKEARRAY function?
The MAKEARRAY function is a powerful tool that returns an array of calculated values based on a set of input values. This function can be used to generate arrays with variable dimensions, making it useful for generating random values.
What can the MAKEARRAY function be used for?
The MAKEARRAY function can be used to generate arrays with variable dimensions, making it useful for generating random values. Additionally, the MAKEARRAY function can be used for:
  • Calculating mathematical operations on a set of data
  • Generating probability models
  • Simulating data
  • Generating numerical patterns
What are the advantages of using the MAKEARRAY function?
The MAKEARRAY function offers several advantages, such as:
  • Efficiently generating numerical patterns
  • Creating arrays with variable dimensions
  • Simulating data quickly and accurately
  • Generating probability models

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV