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

There is certainly an order to them, but sorting them will rearrange the days, instead of listing Friday through Monday. Although Excel offers no automated solution, you can number the entries and ...

Q. I often recruit Excel to do double duty as a database, and there are times I’d like to reverse the order of numbers or names in a table. How can I do that? A. In other words, you want to take a ...