How to realize the difference between the numbers in the column, each subsequent value from the previous dynamically expanding the formula ignore blank cells?

Good afternoon, dear GURUS!

You need to realize the difference between the numbers in the column, each subsequent value from the previous dynamically expanding formula(array) on the entire column, but skip empty cells.

Given: a column with the numbers including empty cells, you need to exercise in the adjacent column the difference between each subsequent number from the previous dynamically expanding formula(a array) (ARRAYFORMULA,QUERY or something else ). In the first condition it is necessary that the difference of numbers was not made, if there is at least one empty cell in the deductible. In the second condition to find the closest previous cell with a number and make the difference of numbers from it.

Manual implementation of what is needed on the link https://docs.google.com/spreadsheets/d/10uNnWb5vVu... access full, it is also possible to write the correct formula.

Thanks in advance, hope to help. Like I understand that just has to be, but already the brain broke.
June 8th 19 at 16:51
0 answer

Find more questions by tags Google