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

It's easy to accidentally miscount the columns, especially if your lookup array is hundreds of columns across. Adding or removing columns could affect the accuracy of the column index number.

The column index number is the column in the table array from which to retrieve the value, starting with 1 for the first column.

Column Index Number: This is the column number in the table array from which you want to retrieve a value. The first column is 1, the second column is 2, and so on.

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.