Forum Discussion
calculation creating unique email address
SergeiBaklan Hi, just got back into looking at this and I really don't understand why the exact same formula works on your excel and not mine. Can you please open the test file below and does the formula show the unique email addresses on your excel ? as mine does not, its doesn't recognize that they are the same email address and then just adds all of the email addresses together. Thank you so much for your help and i'm completely stuck !
That's some negative impact of converting from modern Excel on previous versions.
In general formula works if enter it correctly,
If you see in formula "@" (in red in first block), remove them all. If you see the formula as regular one, enter it as array formula using Ctrl+Shift+Enter. With that it shall look as {=TEXTJOIN(.... }.
You may download the file from pervious thread, it shall be compatible with your Excel, and compare formula in it and this one.