This video compares Excel's new spilled array functionality vs an existing solution that requires mixed cell references.
------------------------