MUO on MSN

Excel's dynamic array functions made me realize I'd been solving problems the hard way for years

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

The simple Excel function that decides if your formula spills or returns one value

Dynamic arrays change the rules for formula output in Excel. When I write a formula that returns a list by default, I need to decide whether I want the result to spill across a range of cells or ...
TechRepublic

Use an Excel array function to create an AverageIf function

Excel doesn’t have a built-in AVERAGEIF() function, but you can still average values, conditionally. Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get ...
Business Insider

Excel Array Formulas

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells instead ...