I have a spreadsheet with a column of data that has frequent gaps. I want to calculate the difference between each of the values in that column and the previous non-blank value in the column; the result will go into a separate column adjacent to the values.
Column E (Weight) is my Data Values and Column F (Change) is where I want to put the difference.
The Weight column can be entered on any row as the table grows and I need to give this to a user that just enters the weight value and nothing else. They are not Excel users so I don't want them copying formula etc.
If I put this formula into the cells in Column F (Change) I get the difference correctly calculated between the adjacent value and the previous value from Column E (Weight)
The issue is that all the blank cells show unnecessary values and so I want to make them invisible.
To fix that I added an IF(ISBLANK statement to the formula to make it
only now I get a #VALUE error.
I am stuck. Can anybody please help?