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

Multiplying numbers in Excel isn't always the easiest thing to do, but it can be done. Here's how to do it in four ways, depending on what you need to multiply.

Learn how to multiply numbers in single cell, multiply multiple numbers from several cells, multiply column of numbers in Excel.