News

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
Your spreadsheet should consist of columns and rows. Row 1 should always be used for headings and each one should be sortable.