Stop updating Excel manually. Discover how to use dynamic array formulas to create self-updating reports and dropdown lists ...

Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

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. Sorting is easy in Excel; you ...