I have a column of numbers. Every so often there is a blank cell with no number. I am trying to write a formula that will output the difference between the number right before a blank cell . . . and the number that followed the previous blank cell. Any ideas as to how to accomplish this in a faster/more productive way without manually doing this for each grouping is appreciated. Thank you.
Example.PNG