Dragging down to continue a list

[Sky188]

Good evening all,

I'm having issues with using the black box at the bottom right to continue down a formula.

On sheet1, I've got a value in column A every 4 cells (A1, A5, A9, etc),

And I need those values to be copied to Sheet2 every 2 cells (A1, A3, A5, etc).

So, Sheet 1 A1 = Sheet 2 A1, Sheet 1 A5 = Sheet 2 A3, Sheet 1 A9 = Sheet 2 A5, etc

I'm currently trying to use the below formula

Please Login or Register  to view this content.

I personally am unsure how this formula works, but I've found most of my issues can be solved by fiddling around with the values, up until now.


What I'm currently trying is this:
On sheet 2, put in the formulas to equal their perspective values on Sheet 1, and have 1 space in between each cell (so again, A1 has value, A3 has value, A5 has value), then I select A1-A6, then use the black box; what I end up getting as a result is A1-A5 on Sheet2 work well, then A7-A12 have incorrect values, then A13-A17 have the correct, and so on.

How do I fix this??

[shg]

Please Login or Register  to view this content.

The formula in C1 is

=INDEX(Sheet1!A:A, 2*ROWS(A$1:A1) -1)

Select both C1 AND C2 and drag down.

[Sky188]

Works perfectly, thanks shg!