Hi,

I have a problem while dragging the formula.

Its better to give an example rather than explaining in the normal way.

I have a formula =C7 in the cell B100 and =F7 in B101..

That means the row number remains the same (7) but the column number needs
to be dragged in such a way that for each cell dragged down (from B100 to
B110 and so on) every third column should be referred (i.e C7, F7, I7, L7 so
on...)

Thanks in advance