Hello,

This is my first post, so please forgive me if I do anything against unwritten law. But, I have a filter on my data in an excel spreadsheet and am trying to input a number with decimals for example 123.45.67.8 into a column and drag the black plus sign at the bottom right of the cell downward to have Excel Auto Fill the data. I would like the subsequent cells to be ascending consecutively (i.e. 123.45.67.9, 123.45.67.10, 123.45.67.11 and so on). Yet, it will only copy 123.45.67.8 all the way down. Furthermore, I have no Auto Fill pop-up box where I can change between Copy Cells or Fill Series. I have concluded that you simply cannot do this with filtered data in Excel. However, does anyone know of a formula that will work for what I'm trying to accomplish?

It would be awesome if it could always reference to the value in the cell above and add 1 to the number.
I have tried the INDIRECT("R[-1]C, 0") terminology with a +1 at the end to no avail.

Environment:
-Excel 2013
-Filtered Data in worksheet
-Win7

Thank you!

-Alex H.