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...
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 ☺️
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
- just google and i found this: "Note: The UNIQUE function is part of the new Excel Dynamic Arrays family and at the time of writing, Dynamic Arrays are only available in Office 365 and are currently in beta on the Insiders channel. Excel 2019 will not have the Dynamic Array functions." really is not English to me.
- I have office 2019 if that helps?