Revamp Current Formulas to build list of sequntial cells numbers 25,50,75,etc..

[robkrouse]

i've attached the resolution that i received from here for a similar question i had.

I needed to create a list of cells numbered 1-20 but with different info at the beginning of each cell, if that makes sense.

It worked nicely.

Now i need a different series of numbers, but I just can't figure out home to change it up to give me what i need.

Originally i needed:
starting Info End Result
testNY
testCA
testMA
testKS
testMO
testAR
testNY1
testNY2
testNY3
testNY4
testNY5
testNY6
testNY7
testNY8
testNY9
testNY10
testNY11
testNY12
testNY13
testNY14
testNY15
testNY16
testNY17
testNY18
testNY19
testNY20
testCA1
testCA2
testCA3
testCA4
testCA5
testCA6
testCA7
testCA8
testCA9
testCA10
testCA11
testCA12
testCA13
testCA14
testCA15
testCA16
testCA17
testCA18
testCA19
testCA20


Now i need:
testNY
testCA
testMA
testKS
testMO
testAR
testNY0
testNY25
testNY50
testNY75
testNY100
testNY125
testNY150
testNY175
testCA0
testCA25
testCA50
testCA75
testCA100
testCA125
testCA150
testCA175

[Glenn Kennedy]

Maybe this??? In d1, copied down:

=IFERROR(INDEX($A$1:$A$6,1+INT((ROWS(D$1:D1)-1)/8))&25*MOD((ROWS($D$1:D1)-1),8),"")

[robkrouse]

Worked like a charm.... TY SO MUCH.