Young Grasshopper
Board Regular
- Joined
- Dec 9, 2022
- Messages
- 58
- Office Version
- 365
- 2016
- Platform
- Windows
Hi,
I have a problem that probably is a quick fix, but I can't seem to figure it out..
I want to drag and copy a formula down, but the reference cell needs to be the same in the first three lines, then move on to the next reference cells for the next three, and so on..
A simplified example with formula in cell underneath each other;
=A1
=A1
=A2
=A2
I want to select and drag these cells down and get; =A1,=A1,=A2,=A2,=A3,=A3,=A4,=A4, and so on.
Instead i get; =A1,=A1,=A2,=A2,=A5,=A5,=A6,=A6,=A9,=A9...
Would appreciate any help
I have a problem that probably is a quick fix, but I can't seem to figure it out..
I want to drag and copy a formula down, but the reference cell needs to be the same in the first three lines, then move on to the next reference cells for the next three, and so on..
A simplified example with formula in cell underneath each other;
=A1
=A1
=A2
=A2
I want to select and drag these cells down and get; =A1,=A1,=A2,=A2,=A3,=A3,=A4,=A4, and so on.
Instead i get; =A1,=A1,=A2,=A2,=A5,=A5,=A6,=A6,=A9,=A9...
Would appreciate any help