Good morning,

I have a column that populates from a formula, some are blank and some have values.. The column has no values from A1 thru A45. A46, has a value. and from A49 thru A75 the cells are empty. While cell A76 has a value. I need to tell my worksheet to subtract the two values, A46-A76. However, the column has about 22,000 values at different cells in the column. The formula needs to be able to "skip" the blank cells and subtract the two closest cells with value. The next subtraction could look like, A109-A127, A143-A166 the cells with values are not proportionally incremented. The column is too large to go through and put a subtraction formula for each instance. Any help would be appreciates. Thanks.