No worries... if you have never heard of an Array formula, you are not alone - most Excel users haven't either. Here you will get your feet and learn the basics of the topic and how Excel is reading these powerful formulas. Don't forget - Ctrl + Shift + Enter!
Text00:10 This video segment provides a comprehensive introduction to array formulas. Although complex, Array Formulas are extremely useful to streamline and simplify worksheets that hold and analyze a large amount of data. Remember, Ctrl+Shift+Enter :).
09:10 When working with complex formulas, such as Arrays, just know that at some point you will screw up. The fastest way to debug is to evaluate your formula using the F9 shortcut key. Select the portion of the formula you want to evaluate, then press F9. Excel will perform the calculation and display the results. Take a look at this example.
VideoGIF
Array-Outlines-1.xlsx