Forum Discussion
calculation creating unique email address
Can anyone help me with a formula please. I have about 8 columns of email address for an individual (some are blank and some are the same email) and want to create a formula in the last column to cr...
Forgot to select only the unique email address.
Try this instead:
=TEXTJOIN("; ",1,UNIQUE(B2:I2,1,0))
The first one works a treat but for some reason when I put unique in the formula it doesn't work for me, saying #name? . Any ideas?
Thank you every so much in replying ☺️
Thank you every so much in replying ☺️
Please check this https://techcommunity.microsoft.com/t5/excel/removing-duplicates-when-using-textjoin/m-p/188950 thread. If you have no UNIQUE() other variants of formula are here.
SergeiBaklan I have attached the file as its easier to explain i think. I also watched the video and tried to copy the formula but it's not removing the duplicates. Any help would be appreciated.
Thanks so much again.
Bennadeau I have attached the file as its easier to explain i think. I also watched the video and tried to copy the formula but it's not removing the duplicates. Any help would be appreciated. My excel doesn't allow the "unique" formula. Think its a version thing. Thanks so much again.
- Also, update your version of Office. If you have 365, the latest update should allow you to use Unique function
