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

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

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

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

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

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

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

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

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

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