As an enhancement to Excel’s calculation engine, the Dynamic Arrays functionality enables a single formula to produce results that expand into other cells, as demonstrated in the SORT example below.

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

An array-based FILTER function in cell L2 repeats the invoice listing in columns L through S, but only for those invoices issued to companies located in Los Angeles. You can see my video demonstrating ...

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

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

Example: I have a 5 x 5 array of data with names of animals in it. I have another cell with "monkey" written in it. Is there a way I can write a formula to test whether or not "monkey" exists in ...

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.