To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

How To Use Excel's LOOKUP Function In Array Form The array form of the LOOKUP function is useful for large datasets organized in a rectangular range with multiple rows or columns.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

How to use UNIQUE () in Excel The dynamic array function, UNIQUE () has been around for a while, so it’s possible that you already know how to use it.

Array: An array, an array formula, or a reference to range of cells to which you want the number of rows. How to use the ROW function in Microsoft Excel Launch Microsoft Excel. Type into the cell ...

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

The LOGEST function calculates an exponential curve that fits your data and returns an array of values that describes the curve. Learn how to use it.

How to Use an Alphanumeric Mix in VLOOKUP Statements in Excel. Excel's VLOOKUP function searches cell arrays for data that you provide. The function often takes cell references as input, letting ...

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.