Every 10 row changes cell reference.

[elmaco]

Hello, i have a problem that i cant find a solution for.
I have B1-B10 thats links to cell A1
I have B11-B21 thats links to A2
i have B22-B32 rows that links to A3
And so on............
How do i fill the next 10000 rows with that pattern in a easy way

Best regards/
Marcus Sweden

 

[steve the fish]

B1:B10 is 10 cells, B11:B21 is 11 cells. Are you sure thats what you mean??

 

[footoo]

Maybe : =OFFSET(A$1,INT((ROW())/11),0)

Put in B1 and fill down

 

[elmaco]

B1:B10 is 10 cells, B11:B21 is 11 cells. Are you sure thats what you mean??

Nope, i meant B11:B20, sorry

 

[elmaco]

Maybe : =OFFSET(A$1,INT((ROW())/11),0)

Put in B1 and fill down

It works perfectly, TNX!!

BR/
Marcus

 

[footoo]

nope, i meant b11:b20, sorry

=offset(a$1,int((row()-1)/10),0)