Summary
In this video, we are looking at broadcasting.
Tab in example file: Broadcasting
Broadcasting is an array behaviour that occurs where arrays of varying sizes are used in calculation. The smaller array is expanded to the size of the larger array to enable calculation to occur based on relative position.
Where the values to broadcast are unclear, Excel uses #N/A for each value.