Repeat text in sequence

[Jstump]

What formula can I use to get the one text to repeat 15 time then switch to another text and have it repeat 8 time then have then alternate another 8 times?

 

[Fluff]

In that case post the text here.

 

[Jstump]

I've downloaded the XL2BB and installed it into excel but whenever i go to run it it says it disabled the macros and then greys out the option for mini sheet or table only and those are the only 2 options i have.

anyways the text to replace A would be 3.5" OD x 0.300" WT x 20' LG, 12"/15" DIA x 0.5" THK HELIX and the text to replace B would be 3.5" OD x 0.300" WT x 15' LG, 9"/15" DIA x 0.5" THK HELIX

 

[Fluff]

Thanks for that, how about

=LET(a,VSTACK(TOCOL(IF(SEQUENCE(,15),"3.5"""" OD x 0.300"""" WT x 20' LG, 12""""/15"""" DIA x 0.5"""" THK HELIX")),TOCOL(IF(SEQUENCE(,8),"3.5"""" OD x 0.300"""" WT x 15' LG, 9""""/15"""" DIA x 0.5"""" THK HELIX"))),TOCOL(IF(SEQUENCE(,8),a),,1))

For the XL2BB have a look here XL2BB Icons greyed out

 

[Jstump]

Is there a way to only have 1 " in the description? it reads 3.5"". I figured out the mini sheet thing so here it is.

As Built Saber.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Piles Installed			0								Job Completion		0.000%
2			PILE TYPE	STRUCTURE NAME	LEAD DESCRIPTION	LEAD DATE INSTALLED		MINIMUM TORQUE FT LBS	MINIMUM DEPTH FT	FINAL TORQUE FT LBS	FINAL DEPTH FT	PILE COMPLETE	INSTALLER
3	HP-01		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
4	HP-02		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
5	HP-03		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
6	HP-04		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
7	HP-05		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
8	HP-06		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
9	HP-07		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
10	HP-08		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
11	HP-09		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
12	HP-10		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
13	HP-11		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
14	HP-12		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
15	HP-13		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
16	HP-14		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
17	HP-15		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
18	HP-16		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
19	HP-17		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
20	HP-18		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
21	HP-19		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
22	HP-20		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
23	HP-21		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
24	HP-22		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
25	HP-23		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
26	HP-24		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
27	HP-25		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
28	HP-26		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
29	HP-27		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
30	HP-28		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
31	HP-29		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
32	HP-30		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
33	HP-31		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
34	HP-32		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
35	HP-33		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
36	HP-34		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
37	HP-35		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
38	HP-36		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
39	HP-37		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
40	HP-38		A		3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX
41	HP-39		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
42	HP-40		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
43	HP-41		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
44	HP-42		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
45	HP-43		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
46	HP-44		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
47	HP-45		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
48	HP-46		B		3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX
Sheet1

Cell Formulas
Range	Formula
D1	D1	=COUNTIF(L3:L1850,"yes")
N1	N1	=D1/1848
A3:A692	A3	="HP-"&TEXT(SEQUENCE(690),"00")
C3:C186	C3	=LET(a,VSTACK(TOCOL(IF(SEQUENCE(,15),"A")),TOCOL(IF(SEQUENCE(,8),"B"))),TOCOL(IF(SEQUENCE(,8),a),,1))
E3:E186	E3	=LET(a,VSTACK(TOCOL(IF(SEQUENCE(,15),"3.5"""" OD x 0.300"""" WT x 20' LG, 12""""/15"""" DIA x 0.5"""" THK HELIX")),TOCOL(IF(SEQUENCE(,8),"3.5"""" OD x 0.300"""" WT x 15' LG, 9""""/15"""" DIA x 0.5"""" THK HELIX"))),TOCOL(IF(SEQUENCE(,8),a),,1))
Dynamic array formulas.

 

[Fluff]

How about

=LET(a,VSTACK(TOCOL(IF(SEQUENCE(,15),"3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX")),TOCOL(IF(SEQUENCE(,8),"3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX"))),TOCOL(IF(SEQUENCE(,8),a),,1))

 

[Jstump]

How about

=LET(a,VSTACK(TOCOL(IF(SEQUENCE(,15),"3.5"" OD x 0.300"" WT x 20' LG, 12""/15"" DIA x 0.5"" THK HELIX")),TOCOL(IF(SEQUENCE(,8),"3.5"" OD x 0.300"" WT x 15' LG, 9""/15"" DIA x 0.5"" THK HELIX"))),TOCOL(IF(SEQUENCE(,8),a),,1))

You are amazing!! Thank you so much. Appreciate all the time you spent on this.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Peter_SSs]

You are amazing!! Thank you so much. Appreciate all the time you spent on this.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.