Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.| support.microsoft.com
Learn more about the SEQUENCE function, which allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. SEQUENCE is in a class of functions called dynamic arrays.| support.microsoft.com
Learn about the RANDARRAY function for creating arrays of random numbers between 0 and 1. RANDARRAY is in a class of functions called dynamic arrays.| support.microsoft.com
To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list).| support.microsoft.com
Learn about the implicit intersection operator (@), which returns a single value using logic known as implicit intersection. The implicit intersection operator (@) may return a value, single cell range, or an error. The implicit intersection operator (@) is in a class of functions called dynamic arrays.| support.microsoft.com
How to correct a #SPILL error in Excel (when a formula returns multiple results and cannot return them to the grid).| support.microsoft.com
Correct a #REF! error in Excel| support.microsoft.com
Learn about how Excel's dynamic, and spilled array formulas behave.| support.microsoft.com
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.| support.microsoft.com
Learn about the SORT function, which sorts the contents of a range or array. SORT is in a class of functions called dynamic arrays.| support.microsoft.com
How to use the FILTER function in Excel to filter a range of data based on criteria you define.| support.microsoft.com