Selecting the part of the array

Evaluating array formulas We can evaluate part of an array by selecting the part of the array formula and then pressing F9 on the keyboard to show values. This is a great way of checking whether the array is using the correct cells: Figure 10.6 – Selecting the part of the array to evaluate Figure […]