Generate series with suffix and prefix but middle change

[feroz_bilal]

Hello
i want to make a list of my products in this way upto 600:

Fbtr-1-s
fbtr-1-m
fbtr-1-l
fbtr-1-xl

fbtr-2-s
fbtr-2-m
fbtr-2-l
fbtr-2-xl

now here fbtr- is prefix and there are four suffix i.e. s,m,l,xl...
i want to change only numeric part 1 to 600.

please guide me.
Regards

 

[Rick Rothstein]

Does this formula (copied down) do what you want...

=IF(MOD(ROWS($1:1),5)>0,"fbtr-"&1+INT((ROWS($1:1)-1)/5)&CHOOSE(1+MOD(ROWS($1:1)-1,5),"-s","-m","-l","-xl"),"")

 

[feroz_bilal]

Thank u sir for prompt reply.
The formula is working but how can i make a series from 1 to 600 and also i want repetition of numbers 4 times with different sizes. Kindly look to this link, i want exactly the same.
http://i.imgur.com/Hgc5pCK.png
Regards

 

[mikerickson]

Perhaps
="fbtr-" & CEILING(ROW(A1)/4,1) & CHOOSE(MOD(ROW(A4),4)+1,"-s,"-m,"-l","-xl")

 

[Rick Rothstein]

Thank u sir for prompt reply.
The formula is working but how can i make a series from 1 to 600 and also i want repetition of numbers 4 times with different sizes. Kindly look to this link, i want exactly the same.
http://i.imgur.com/Hgc5pCK.png
Regards

What you said you wanted in Message #1 is different than what you show in your picture (no blank rows between groups, numbers are three digits long)... you should have showed us the picture first. Here is the new formula and instructions how to create list with it...

1) Type A1:A1200 in the Name Box (the field to the left of the Formula Bar) and then press Enter. This will select 1200 cells in Column A.

2) Copy/Paste this formula into the Formula Bar...

="FBTR-"&TEXT(1+INT((ROWS($1:1)-1)/4),"000")&CHOOSE(1+MOD(ROWS($1:1)-1,4),"-S","-M","-L","-XL")

3) Commit the formula using CTRL+ENTER (note, use only those two keys).

 

[feroz_bilal]

What you said you wanted in Message #1 is different than what you show in your picture (no blank rows between groups, numbers are three digits long)... you should have showed us the picture first. Here is the new formula and instructions how to create list with it...

1) Type A1:A1200 in the Name Box (the field to the left of the Formula Bar) and then press Enter. This will select 1200 cells in Column A.

2) Copy/Paste this formula into the Formula Bar...

="FBTR-"&TEXT(1+INT((ROWS($1:1)-1)/4),"000")&CHOOSE(1+MOD(ROWS($1:1)-1,4),"-S","-M","-L","-XL")

3) Commit the formula using CTRL+ENTER (note, use only those two keys).

Thank you very much sir...Really thanks a lot.
I was stuck in this..
This worked very well....
Regards

 

[feroz_bilal]

Perhaps
="fbtr-" & CEILING(ROW(A1)/4,1) & CHOOSE(MOD(ROW(A4),4)+1,"-s,"-m,"-l","-xl")

Hello sir,
thank u for the reply, Mr. Rick's method worked for me.
And thank u for prompt reply.
Regards