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

Random Sort in Excel You can generate random numbers in Excel and use them in conjunction with Excel's sorting feature to have Excel randomize a list of data.

It's easy to return random values in Microsoft Excel, but returning random letters might leave you scratching your head. Fortunately, you only need two functions.

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.