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 …

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

Once you enter a spilled array formula, when you select any cell within the spill area, Excel will place a highlighted border around the range. The border will disappear when you select a cell outside of the …

Use array constants in array formulas or by themselves to save time, and when you need values that aren't in your workbook.

These examples use the INDEX function to find the value in the intersecting cell where a row and a column meet. Copy the example data in the following table, and paste it in cell A1 of a new Excel …

An array is a collection of values in rows and columns (like a table) that you want to search. For example, if you want to search columns A and B, down to row 6.

For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH (25,A1:A3,0) returns the number 2, because 25 is the second item in the range.

Where an old formula could invisibly trigger implicit intersection, dynamic array enabled Excel shows where it would have occurred with the @. Why the @ symbol? The @ symbol is already used in …

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

The RANDARRAY function returns an array of random numbers. You can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal …