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...
I realized I must have been blinded by the Einstellung Effect! My earlier formula should have been shortened to this:
=IFERROR(IF(B2="","",
B2-LOOKUP(2,1/(B$1:B1<>""),
B$1:B1)),B2)
See the foregoing formula in C2 of the attached file.