I have a formula that breaks when 'nothing' is in any of the cells:
I'm expecting this of course, as I haven't told it to do anything when
Am I going in the right direction with this or is there a simpler way?
Because I am afraid that I will have to do every scenario for every TRUE FALSE in each
IF() branch and my real problem is that it has 19 cells that I would like to use if they contain something.
I have a sample sheet here "Concat Cells if not empty".