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

SEE: How to use Find All to manipulate specific matching values in Excel (TechRepublic) Listing A shows a macro that automates the simple two-column sort that we ran in the last section.

Stay tuned Excel supports a second custom support: sorting by multiple columns. In a future article, I’ll show you how to use this same feature to sort by multiple columns.

How to Reverse a Column Order in Microsoft Excel. Reversing the order of a column would be easy if the column was already listed alphabetically or sequentially; you would just sort in the other ...

How to compare columns in Microsoft Excel As stated, we can use the Excel VLOOKUP function to find and match different data or find differences in two columns.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.