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

A to Z of the Self: Sheila Heti’s ingenious new book, Alphabetical Diaries, takes 10 years of diary entries and rearranges them in alphabetical order.

Every now and then I have to reverse the order of a long list in Excel that is not in alphabetical or numerical order—a tedious job. Do you know of a shortcut? Yes, you can adapt Custom Lists, a tool ...