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

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

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.

This post will show you how to filter or sort Excel data using Cell Color and Font Color the easy way. This helps organize cells & improve productivity.

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.

Structured references in Excel tables automatically expand and contract with data, maintaining accurate reports.