MAKEARRAY Function

Description

Returns an array with the specified row and column size, based on applying Lambda function.

NOTE

• The function will return a #VALUE! when you providing an invalid Lambda function.

Syntax

Copied!=MAKEARRAY(rows, cols, LAMBDA(row, col, body))
=MAKEARRAY(rows, cols, LAMBDA(row, col, body))

EXAMPLE 1

Copied!//𝘴𝘦𝘦 𝘪𝘯𝘪𝘵𝘪𝘢𝘭 𝘷𝘢𝘭𝘶𝘦𝘴 ​​𝘧𝘰𝘳 𝘳 𝘢𝘯𝘥 𝘤
=MAKEARRAY(3, 3, LAMBDA(a, b, "r="&a&", c="&b))
//𝘴𝘦𝘦 𝘪𝘯𝘪𝘵𝘪𝘢𝘭 𝘷𝘢𝘭𝘶𝘦𝘴 ​​𝘧𝘰𝘳 𝘳 𝘢𝘯𝘥 𝘤
=MAKEARRAY(3, 3, LAMBDA(a, b, "r="&a&", c="&b))

|   | A        | B        | C        |
|---|----------|----------|----------|
| 1 | r=1, c=1 | r=1, c=2 | r=1, c=3 |
| 2 | r=2, c=1 | r=2, c=2 | r=2, c=3 |
| 3 | r=3, c=1 | r=3, c=2 | r=3, c=3 |

example 2

Copied!//𝘤𝘳𝘦𝘢𝘵𝘦 𝘶𝘱𝘱𝘦𝘳 𝘵𝘳𝘪𝘢𝘯𝘨𝘶𝘭𝘢𝘳 𝘮𝘢𝘵𝘳𝘪𝘹 𝘸𝘪𝘵𝘩 𝘪𝘯𝘪𝘵𝘪𝘢𝘭 𝘷𝘢𝘭𝘶𝘦 = 1
=MAKEARRAY(4, 4, LAMBDA(r, c, (r<=c)*1))
//𝘤𝘳𝘦𝘢𝘵𝘦 𝘶𝘱𝘱𝘦𝘳 𝘵𝘳𝘪𝘢𝘯𝘨𝘶𝘭𝘢𝘳 𝘮𝘢𝘵𝘳𝘪𝘹 𝘸𝘪𝘵𝘩 𝘪𝘯𝘪𝘵𝘪𝘢𝘭 𝘷𝘢𝘭𝘶𝘦 = 1
=MAKEARRAY(4, 4, LAMBDA(r, c, (r<=c)*1))

|    | A | B | C | D |
|----|---|---|---|---|
| 1​  | 1 | 1 | 1 | 1 |
| 2  | 0 | 1 | 1 | 1 |
| 3  | 0 | 0 | 1 | 1 |
| 4  | 0 | 0 | 0 | 1 |

RELATED