Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

The FILTER function in Excel is a powerful tool that allows you to extract specific data from a range, of data lists or an array based on multiple criteria.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

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

In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful.

To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in the case of two-dimensional ...