To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

How to Make a Graph With Months in Excel. When you create a graph that includes dates, Excel 2013 automatically spaces the data in chronological order.

The Sort By control displays Month with an Ascending sort. If you click OK, Excel will sort the selected months in alphabetic order. Click the Options button at the bottom of the dialog box.

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 ...