How to fill cells A1, A2, A3... with contents from B1, B4, B7...

[Guest]

Hi,

I am trying to copy contents from, say, B1, B4, B7, .... into A1, A2,
A3,.... And did not know how to set up a formula to do that. I'd appreicate
for any suggestions.

Thanks,
Xianbo

 

[Guest]

If you're trying to copy every third row from B to A, enter the formula
=OFFSET($B$1,ROW()*3-3,0) in A1, and autofill down through the appropriate
cells in column A.

 

[Domenic]

Try...

A1, copied down:

=OFFSET($B$1,ROWS($A$1:A1)*3-3,0)

Hope this helps!

 

[Guest]

Thanks. That works great!

If you're trying to copy every third row from B to A, enter the formula
=OFFSET($B$1,ROW()*3-3,0) in A1, and autofill down through the appropriate
cells in column A.

 

[Guest]

Thanks. That works great!

Try...

A1, copied down:

=OFFSET($B$1,ROWS($A$1:A1)*3-3,0)

Hope this helps!