Learn about the SORTBY function, which sorts the contents of a range or array based on the values in a corresponding range or array. SORTBY is in a class of functions called dynamic arrays.| support.microsoft.com
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum every nth value in a range of values.| 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
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
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