Getting datas every 3 rows

Hi,

I got a problem, and i don't know how to solve it.

I'd like to get the datas of a collumn in an other sheet, but i'm only interested at every three rows datas.

Is it possible to calculate a value first of a collumn?

So doing like:
=A1
=A(1+3)
= A(4+3)
...


Result expected:
='MySheet'!A1
='MySheet'!A4
='MySheet'!A7
...

Try this:

=INDEX('MySheet'!A:A,ROWS($1:1)*3-2)

then copy down.

Hope this helps.

Pete

@martin:

you missed the !

Pete

I should have taken a screenshot !!

Pete

I must not understand something there:
INDEX( reference, row_number, [column_number], [area_number] )

I don't arrive to adapt it at my needs ^^.

So:

=INDEX('MySheet'!A:A;ROWS($A$1:A1)*3-2)

'MySheet'!A:A; all the column where i need to get the datas

ROWS($A$1:A1) <--- number of lines between the range, so will be incremented by 1

*3-2 ( to do 1,4,7 ... )
So if i wanted every 13 starting from 3 it should be:
ROWS(A$1:A1)*13-10

If i try the rows function it's working, giving: 3,16,29 ...

But when i try the complete expression, it doesn't work:
=INDEX('MySheet'!A:A,ROWS(A$1:A1)*13-10)
or ';' instead of ',' as it was giving an ERROR
=INDEX('MySheet'!A:A;ROWS(A$1:A1)*13-10)

Any idea ?

Thank you !!

Indeed it works, it seems i was too tired yesterday night xD

Thank you !