Let’s take a look at a few examples.
The first way to see arrays is to enter formulas or expressions directly on the worksheet.
For example, here we have some numbers in therangeB5:B14.
In cell E5, I have a formula that squares and then sums the values in the range.
Any change to the source data is immediately reflected.
So, this is one way to see arrays.
One advantage here is that we can easily see the dimensions of the array directly on the worksheet.
I’ll undo that change now.
Another way to see arrays is to use the F9 key.
To undo this step, use control + z.
Often, you’ll want to check the values in an array being passed into a function as anargument.
This means you gotta carefully choose the entire expression being provided to the function.
you’ve got the option to use this trick in any function.
To back out of the formula completely without making any changes press the escape key.
Let’s look at one more example on the second sheet.
On this worksheet, we are counting unique values with a formula that uses bothCOUNTAandUNIQUE.
you’ve got the option to use the F9 key to evaluate any formula.
