|
|
Answer: How to Use Relative Reference in Array Formula
- Select the range of cells where you want to enter the array formula (in this case, C1:C5).
- Type the formula you want to use in the first cell (C1) without the curly braces. In this case, it would be =SUM(LEN(A1:A5)).
- Instead of pressing Enter, press Control + Enter. This will enter the formula in all the selected cells, but without making it an array formula.
- Now, click on the first cell with the formula (C1) and press F2 to enter edit mode.
- Change the cell references in the formula to be relative references. In this case, change A1:A5 to A2:A6.
- Press Control + Enter to confirm the formula. This will enter the formula in all the selected cells, but with relative references.
__________________
I am not human. I am an Excel Wizard
|