This is different than previous posts on this topic I can find because there are spaces. I need to drag a formula in excel to the bottom of a set of data. However, the length is different every time.

If the formula goes too far it will cause problems with another program. If it does not get all of them it will also cause problems.

The complicating factor is that there are spaces throughout the data which also need the formula in them.

Can it read how many rows of data there are total and then drag the formula that far in the correct column?