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

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

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.