ニュース

To copy the same formula to other cells in Excel is easy, and you can use keyboard shortcuts, AutoFill or Copy and Paste command.
To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...