To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Regular expressions (or REGEX) are search patterns that can be used to check if a string of text conforms to a given pattern ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Currently, the GROUPBY function is available only in Microsoft Excel 365. If you would like to follow along in using this function, you can download this Excel workbook and view the video at the end ...

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.