Formula Question

[CatherineMadden]

Hello, how do I continue filling the following. I have about 2000 set of data that I don't want to have to do it the hard way. I need the letter to stay the same, but the number to count up 1 digit at a time. When I "fill formatting" it will be B1 to B10 and I need it to be B2. I hope that makes sense.

=B1

=D1

=F1

=H1

=J1

=L1

=N1

=B2

=D2

=F2

=H2

=J2

=L2

=N2

[#2 · Accepted solution]

@CatherineMadden 

=IFERROR(CHOOSE(MOD(ROW(),8),INDIRECT("B"&QUOTIENT(ROW(),8)+1),INDIRECT("D"&QUOTIENT(ROW(),8)+1),INDIRECT("F"&QUOTIENT(ROW(),8)+1),INDIRECT("H"&QUOTIENT(ROW(),8)+1),INDIRECT("J"&QUOTIENT(ROW(),8)+1),INDIRECT("L"&QUOTIENT(ROW(),8)+1),INDIRECT("N"&QUOTIENT(ROW(),8)+1),""),"")

You can try this formula which is in cell A1 and filled down.

[#3]

Thank you, you are a lifesaver!!