Concatenate works all but one time

[gmcconnell]

I have attached my wedding guest list. I have a column in which I have concatenated all of the email addresses ('X') and the appropriate semi-colons so I can quickly copy and paste the whole list. It seems to work 102 out of 103 times. I can't really explain any further because I am simply dumbfounded, I think I have been looking at it too long!

Any help would be greatly appreciated as this is driving me crazy!

PS, is there a more elegant or quicker way to accomplish this same task without macros or creating a new distribution list in outlook every time the list changes?

[tigeravatar]

gmcconnell,

That is very weird. Cell X58 is reading cell X57 as empty, so it starts the chain over. Here's a more condensed version of the formula you're using that will give the same results:
=IF(X1<>"",IF(N2="",IF(O2="",X1,X1&"; "&O2),IF(O2="",X1&"; "&N2,X1&"; "&N2&"; "&O2)),IF(N2="",IF(O2="","",O2),IF(O2="",N2,N2&"; "&O2)))

However, in order to correct the problem, I had to copy the data into a new worksheet. I have no idea what was causing the issue though Attached is a modified version of your workbook with the issue corrected.