Where possible, we’ve included examples with some of the dynamic array functions, as well as existing array formulas entered as both dynamic and legacy arrays.

If you are writing a dynamic array formula to act on a list of data, it can be useful to place it in an Excel table, then use structured references to refer to the data.

This new dynamic array behavior can also affect earlier functions that have the ability to return a multi-cell range or array. Below is a list of functions that could return multi-cell ranges or arrays in what we …

Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.

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

Lists all Excel functions by their category, such as Logical functions or Text functions.

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.

Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and …

An array can be thought of as a row of values, a column of values, or a combination of rows and columns of values. In the example above, the array for our SORTBY formula is range D2:E9.

How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.