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...
That could be
=IF($B2>0,$B2-INDEX($B:$B,AGGREGATE(14,6,1/(LEN($B$1:INDEX(B:B,ROW()-1))>0)*ROW(B:B),1)),"")and drag it down, please see in attached.