When I pull a cell down the cells are usually filled with a series of numbers that increase by 1.
1, 2, 3, 4, 5 etc.
I want to pull a cell and get all the other cells filled by an increment of 6
1,7,13 etc.
How do I go about doing so?
In excel I just have to fill the first three cells with the series I want and it fills automatically. Is there any way I can do something like this in Librecalc?
Also, I would like for this to apply to formulas as well.
I enter 1 to A1, 7 to A2, select them both and drag-copy, and it works.
This works for numbers but when I try with cell references it makes no sense.
In cells B1 and B2 I enter the following: =A1 and =A7. Then, when I pull down the handle it gives me:
A1, A7, A3, A9It makes sense, just not what you expect. It just copies the formulas as you put them: in first cell “reference to the cell to the left”, in second “reference to cell one left and 6 below”. So it goes. To make what you want, you need to construct the reference: =OFFSET($A$1;(ROW()-1)*6;0;1;1)
I don’t quite follow. This is exactly what I’m trying to do:
In column A I have references to cells on another sheet. Sheet1.A1, Sheet1.A7, Sheet1.A13 etc.
I want this series to fill automatically on the reference so I don’t have to write them manually and I get a reference of every 6th cell in Sheet1.
I provided the formula to you. You only need to add the sheet name: =OFFSET(Sheet1.$A$1;(ROW()-1)*6;0;1;1)