Forum Discussion

Spencer2430's avatar
Spencer2430
Copper Contributor
Nov 06, 2023
Solved

forming a pre meditated paragraph

hi,    I am looking to form a series of pre built paragraph's from a table i have made, effectively I am looking to gather multiple different sentences into one cell.    the top 9 statements are ...
  • OliverScheurich's avatar
    Nov 06, 2023

    Spencer2430 

    =TEXTJOIN(" ",,FILTER($B$1:$B$9,BYROW($A$1:$A$9=B12:J12,LAMBDA(x,OR(x)))))

     

    With Office 365 or Excel for the web you can apply this formula. The formula is in cell K12 and filled down in this example.

Resources