Analytics and Output Reporting 143
There are two important rules to remember when using an array function. Any
arrays referenced within the formula must be of equal length; otherwise an error
will be returned. Also, array functions must be entered by pressingCtrl + Shift
+Enterinstead of simply Enter. An array function that is successfully entered can
be identified with the{}symbols surrounding it.