Can anyone help me with this as I have a long complicated formula that works, but is a bit of a pain to edit when needed.
I have one column with quantities of speakers being installed in a room with values in from D3 to D39. This may have a number in it or may be blank.
What I want to get to is a formula that goes through this column and only writes a line in a cell if there is a number in this column.
the line that is written in the cell will be from the cells to the left of the quantity column and will also include the quantity column.
So the data would look like
I have found that as long as word wrap is turned on the Char(13) will insert a carriage return to nicely put all these all on separate lines.
I hope you can help.