Increasing Cell

[jmsutod]

I have two worksheets. One has a list of account numbers, and sheet two needs to have nine itterations of that account number. While being extremely naive, I tried this:

=Sheet2!$A$2$ (for the first nine iterations of the first account number)
=Sheet2!$A(2+b1) (B was the column I was going to run single digits down to increase the value).

It ended in a collosal mess...so what I'm trying to figure out how to do, is get nine iterations of each account number from sheet 2 to appear in column 1 of sheet 1 without having to do it manually (there are 300 of these babies).

Thanks!

 

[Jonmo1]

Welcome to the board...

Try

=INDEX(Sheet2!A:A,ROUNDUP((ROWS(A$1:A1))/9,0)-1+2)

I know the -1+2 seems silly, but it's there to help understand formula for adjustment purposes.
There's a reason for the madness

the 9 represents the interval - every 9 rows
the 2 represents the row to begin in.
DO NOT CHANGE the A$1:A1 part, it has nothing to do with the location of your data.


Hope that helps.

 

[jmsutod]

Amazing...sigh, I wish I were smart and good looking...

 

[Jonmo1]

Amazing...sigh, I wish I were smart and good looking...

Yes, I wish you were too...

Just kidding.

Don't feel bad, this was not an easy easy thing to do in Excel.
I only responded so quickly because I've done it before...

Glad to help.