Selecting every 3rd row ???

[Larry]

I have multiple consecutive rows that get information from every third row
earlier in the spread sheet, is there a way to reference my 2nd row to the
first row in a formula.

Example:

I have information in Column A Rows 1,4,7,10,13, ect......
I want row 300 to look @ A - Row 1, 301 @ 4, 302 @ 7, ect....

In A300 (=A1)
In A301 can I add a function referencing (=A1+3) in any way so that it would
add 3 to the reference cell A301 looks at to give the value of (=A4).

 

[Domenic]

Try...

A300, copied down:

=OFFSET($A$1,(ROW()-ROW($A$300)+1)*3-3,0)

Hope this helps!