skip 44 rows, name, skip 44 rows, return name

[ammartino44]

Hello. I have cells down a column. How can I return the first value in A1, then skip 44 rows, and put that value in A2, then skip 44 rows and put that value in A3, etc. A code is fine but a formula also works. Thank ye.

[Sam Capricci]

Are you saying that there are values in A1 and A2 and down but you want the value in A44 to overwrite it, an the value in A88 to overwrite the value in A2?

[ammartino44]

No, there are no values in column A. Let's say the data is in column B. I want A1= B1, A2= B55 and so on (skipping 44 rows for each input into column A. Capisce?

[José Augusto]

Try this formula in A1. Data is in column B: A1=B1; A2=B44; ...
=OFFSET($B$1,(ROW(A1)-1)*44,0)

Please Login or Register  to view this content.

Regards

[newdoverman]

This version is similar to that of José Augusto but will allow you to insert rows above the columns without disrupting the formula results if you might have need of the ability to do so.

Please Login or Register  to view this content.

[ammartino44]

This that good good. Thank ye.