Forum Discussion

Carlo74's avatar
Carlo74
Copper Contributor
Feb 16, 2020

Excel formula similiar to texjoin

hy all   I need help if is possible. I need formula to read a complete row and when find data combine it with cell name where data is found, and to skip blanks and zeroes, and move on to next tnx...
excel
office 365
Patrick2788's avatar
Patrick2788
Silver Contributor
Feb 17, 2020

Carlo74 

Dynamic array solution:

=IFERROR(FILTER(FILTER($C$3:$Z$3&$C$3:$Z$27,$B$3:$B$27=$B30),LEFT(FILTER($C$3:$Z$27&$C$3:$Z$3,$B$3:$B$27=$B30))<>"0"),"")

  • Carlo74's avatar
    Carlo74
    Copper Contributor
    Feb 17, 2020

    Patrick2788 ,

    Thanks

    this solution also works great, but I can't use dynamic formulas because it cant be inserted into a table.

    I need table because flow cannot rad data outside a table.

    but tnx, this is great solution, I hope I will learn to write similiar formulas one day 🙂

     

Resources