This video demonstrates how to create array formulas in the Excel. It also compares array formulas in old and new versions of Excel.
------------------------