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

Microsoft is opening up Excel to developers with a new JavaScript API. It will let developers use custom data types like images, cards, and arrays.

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.

INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works with vertical and horizontal datasets, can search in any direction, and ...