I have the following number series:
B1=1000
B2=1005
B3=1010
B4=1015
B5=1020
B6+1025
etc etc all in increments of 5. However, I have some completely random cells
in the same column that I must leave blank. Since I used the fill handle to
copy down the number series, how can I delete random cells and have the
number series readjusted automatically e.g as follows:
B1=1000
B2=blank
B3=1005
B4=1010
B5=blank
B6=1015
Greatly appreciate your help. Excel 2003.