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

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.

"Xianbo" wrote:

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

Try...

A1, copied down:

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

Hope this helps!

In article ,
Xianbo wrote:

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

Thanks. That works great!

"bpeltzer" wrote:

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.

"Xianbo" wrote:

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

Thanks. That works great!

"Domenic" wrote:

Try...

A1, copied down:

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

Hope this helps!

In article ,
Xianbo wrote:

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