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]

Maybe

=LET(a,VSTACK(TOCOL(IF(SEQUENCE(,15),"A")),TOCOL(IF(SEQUENCE(,8),"B"))),TOCOL(IF(SEQUENCE(,8),a),,1))

 

[Jstump]

What if the text i need to repeat has quotations in it?

 

[Fluff]

Please post some sample data & expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Georgiboy]

As Fluff has stated, we would need to see more of what you have to start with, we don't know if you want to hardcode the values into the formula OR if you have the data on the spreadsheet as below:

Book1 (2).xlsx
	A	B	C	D
1	Tesx	Rpt Times		Result
2	Text "one" here	15		Text "one" here
3	Text two	8		Text "one" here
4	Text "" 3 here	8		Text "one" here
5				Text "one" here
6				Text "one" here
7				Text "one" here
8				Text "one" here
9				Text "one" here
10				Text "one" here
11				Text "one" here
12				Text "one" here
13				Text "one" here
14				Text "one" here
15				Text "one" here
16				Text "one" here
17				Text two
18				Text two
19				Text two
20				Text two
21				Text two
22				Text two
23				Text two
24				Text two
25				Text "" 3 here
26				Text "" 3 here
27				Text "" 3 here
28				Text "" 3 here
29				Text "" 3 here
30				Text "" 3 here
31				Text "" 3 here
32				Text "" 3 here
Sheet2

Cell Formulas
Range	Formula
D2:D32	D2	=TOCOL(IF(SEQUENCE(,MAX(B2:B4))<=B2:B4,A2:A4,NA()),3)
Dynamic array formulas.

 

[Jstump]

Here is a screen shot. the text in column F is what i am trying to get to repeat. I copied your formula with the "A" and "B" in column E for reference. I could not get the add in to work in my excel.

 

[Fluff]

Where is the text coming from?

 

[Jstump]

I had to input the text manually into the cell then copy and paste down. I'm trying to get away from that and just have the formula input the text in sequence.

 

[Fluff]

But where is the text coming from, or do you want the text in the formula itself?

 

[Jstump]

I want the text in the formula.