Returns a calculated array of a specified row and column size, by applying a LAMBDA function

Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results.

The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as existing …

Excel has limited support for dynamic arrays between workbooks, and this scenario is only supported when both workbooks are open. If you close the source workbook, any linked dynamic array …

When you enter an array formula, you most often use a range of cells in your worksheet, but you don't have to. You can also use array constants, values you just enter in the formula bar inside braces: {}.

Learn about the UNIQUE function, which returns a list of unique values in a list or range. UNIQUE is in a class of functions called dynamic arrays.

The RANDARRAY function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER.

If you need to use ranges that are located on different sheets from each other, it is recommended that you use the array form of the INDEX function, and use another function to calculate the range that …

The array form is provided for compatibility with other spreadsheet programs, but it's functionality is limited. An array is a collection of values in rows and columns (like a table) that you want to search.

The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In the following example, we created an array that's 4 rows tall by 5 columns wide with …