locksmith55
New Member
- Joined
- Mar 6, 2022
- Messages
- 22
- Office Version
- 365
- Platform
- Windows
I am trying to make a formula that will dynamic print sequence of repeating text where I can specify number of rows I want to print for every text. I tried assigning the text values and using small() and sequence() but it didnt work. Is there any way of doing that dont require a too complexe solution?
I appreaiacte any help I can get. I use MS365 office.
I appreaiacte any help I can get. I use MS365 office.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Numbers of rows to repeat | 5 | ||||
2 | Apples | |||||
3 | Pears | |||||
4 | Bananas | |||||
5 | ||||||
6 | How I want it to look | |||||
7 | Apples | |||||
8 | Apples | |||||
9 | Apples | |||||
10 | Apples | |||||
11 | Apples | |||||
12 | Pears | |||||
13 | Pears | |||||
14 | Pears | |||||
15 | Pears | |||||
16 | Pears | |||||
17 | Bananas | |||||
18 | Bananas | |||||
19 | Bananas | |||||
20 | Bananas | |||||
21 | Bananas | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B7:B11 | B7 | =$A$2 |
B12:B16 | B12 | =$A$3 |
B17:B21 | B17 | =$A$4 |