Forum Discussion
Carlo74
Feb 16, 2020Copper Contributor
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...
Carlo74
Feb 17, 2020Copper Contributor
here's my original file on second sheet SergeiBaklan
tnx again
SergeiBaklan
Feb 17, 2020Diamond Contributor
Please check adjusted to your ranges formulas in attached file.
- Carlo74Feb 17, 2020Copper Contributor
- SergeiBaklanFeb 17, 2020Diamond Contributor
Carlo74 , you are welcome, glad to help.
Perhaps such result could be generated directly from your source table, but that's only the guess, I didn't check the logic.
- Carlo74Feb 17, 2020Copper ContributorYes,
Now with your formula, I think it could be possible by combine those formulas.
As idea it was hard for me already to get result what I want. And I was looking too complicated solutiins.
This makes averything more simple now.
Thank you