Select every nth cell in a row

[newbie369]

Hi all!

I know this question was asked several times, however I couldn't find an answer, which I could use.

I have some data in the 8th row, starting from column G (about 100 values).
For example: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18.... with 1 being in cell G8


I want to be able to have a column of values from the mentioned row, but with every 5th value as follows:
1
5
10
15
20
...


Is it possible to do this by writing formula in the first cell of that column and dragging it down?
Also, does it matter where the formula will be placed?

Thanks in advance...

[Pete_UK]

Put this in your first cell:

=G8

In the cell below it you can use this formula:

=INDEX($G:$G,(ROWS($1:1)-1)*5+12)

then copy down. Note that your first value is not in sequence (it would be 0 if it was), which is why you need a different formula for the first cell.

Hope this helps.

Pete

[daffodil11]

I went with:

Please Login or Register  to view this content.

But you'll need to re-examine your pattern.

1, 5, 10 is a pattern of +4, +5

Instead of + 5 +5

[newbie369]

Thanks! It took me a while to figure out how to properly apply the formula (I guess it is because in my excel I have letters horizontally and numbers vertically.

So finally I used the folloring formula:
=INDEX($8:$8,(ROWS($1:1)-1)*5+11)

Also, could you please help me, what should be changed if I want the column to show numbers starting from 25 for example.

Thank you so much for your time!

[newbie369]

Sorry, but I couldn't apply this formula and since it is a bit too complicated for such a newbie as me, I couldn't figure it out.

I went with:

Please Login or Register  to view this content.

But you'll need to re-examine your pattern.

1, 5, 10 is a pattern of +4, +5

Instead of + 5 +5