On the attached spreadsheet I can't get the concatenate function to join text strings without putting in surplus commas. In each helper cell on the right eg. CH4 I only want it to return the text from D3 if D4 is red and E3 if E3 is red etc. I can get it to work but there are extra commas when nothing is to be joined into the text string. It's not a major issue but a bit annoying as it doesn't look as good when mailmerging.
Any help would be great.
Thanks
Bookmarks