I want to add a formula to multiple cells in a column without typing them all out. now don't just tell me about the fill option as that does not do what I want (as far as I can tell).
When I used that all the cell references in the formula are incremented by 1 as you drop a row. But I have a cell range in it and I want this to stay the same for the whole series i.e. cells B1:B100, not B2:B101, B3:B102 etc because this just then starts to look at part of the column that does not contain my data range.
is there away around this? to force the feature to keep the data range the same always but just increment the criteria field which I want to increment