A Use a formula as a delimiter for TEXTJOIN

[wdgor]

I am using the TEXTJOIN formula below to generate the text presented.

=TEXTJOIN(CHAR(10)&CHAR(42)&" ",TRUE,IF(('Test 2022'!$W:$W=$A4)*('Test 2022'!$AB:$AB="Jan")*('Test 2022'!$D:$D="Yes"),'Test 2022'!$F:$F,""))

Text:

legacy pricing, fees start when training and implementation starts on 3/1/2022 * ramp up pricing over first 2 years, yearly fees due to ARR under $5k * Requires additional contract, 2 fee structures for order form and disclosure

It works perfectly in that it creates an "*" and line feed between each element. I would like to replace the "*" with a sequential number so the output would be numbered:

1. legacy pricing, fees start when training and implementation starts on 3/1/2022
2. ramp up pricing over first 2 years, yearly fees due to ARR under $5k
3. Requires additional contract, 2 fee structures for order form and disclosure

Is that possible with TEXTJOIN? Thanks for your review and suggestions.

 

[wdgor]

Ah, since I sent the original formula, I have been working on the sheet and added a column to the reference data worksheet. It now produces a 5, which is the expected result. Thanks for all your help and have a good night's rest.

 

[wdgor]

My sincere apologies. From the time I sent the original formula, I continued to work on the sheet and added a new column. I realized it when you sent your last message. When I adjusted your original formula with the new column values, it worked perfectly. I have never used the FILTER or LET function and will be sure to investigate those more for their potential. Again, sorry for the oversight and thanks for a great solution. Now, you can rest easy.

=IFERROR(LET(f,FILTER('Test 2022'!$F:$F,('Test 2022'!$W:$W=$A4)*('Test 2022'!$AB:$AB="Jan")*('Test 2022'!$D:$D="Yes")),c,CONCAT(SEQUENCE(ROWS(f))&". "&f&CHAR(10)),LEFT(c,LEN(c)-1)),"")

 

[jasonb75]

I continued to work on the sheet and added a new column. I realized it when you sent your last message.

We've all been there and made that mistake, it's easily done. Glad you got it working