Forum Discussion
Return the value of previous non empty cell in the same column
Hello, I need to find the difference between 2 cells in a column from my data Attached excel is a sample of how I want the result to be (which I did manually), But my data is vast so I want a...
In the attached file, the formula in C2, copied down rows, is:
=IFERROR(IF(B2="","",
B2-INDEX(B:B,
LOOKUP(2,1/(B$1:B1<>""),ROW(B$1:B1)))),B2)