Another Issue with previous row/column references
This is a (simpler, I believe) variant of referring to PREVIOUS rows/columns issue but I still can’t get my head around it:
Given this:
I want to insert in B2 a dynamic function which will show in each cell (B2:E2) the Row 1 value of the current column minus (or plus or whatever) the Row 2 value in the immediately preceding column, resulting, in this case, in
10 15 15 25
Using the bleeding edge version of 365.
This is a (simpler, I believe) variant of referring to PREVIOUS rows/columns issue but I still can’t get my head around it:Given this:I want to insert in B2 a dynamic function which will show in each cell (B2:E2) the Row 1 value of the current column minus (or plus or whatever) the Row 2 value in the immediately preceding column, resulting, in this case, in 10 15 15 25 Using the bleeding edge version of 365. Read More