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

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.

When you're editing a business spreadsheet, you'll sometimes find a column of data in Excel needs to be split into two columns to improve sorting or extracting records. For example, phone numbers ...

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. Here's how to do it.

Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column ...

If you intend to obtain a list of all dates or data between two given dates in Excel, then you can Use the Fill handle or use a Formula. Learn how.

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.