Turns out half my old formulas were just dynamic arrays in disguise, written the long way.
Excel formulas don’t have to be ugly.