Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Microsoft calls this process “spilling” and refers to all Excel formulas producing multiple results as “spilled array” formulas. Earlier Excel editions provide similar array functionality but require ...