Forum Discussion
Helen15
Nov 20, 2020Copper Contributor
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...
Bennadeau
Nov 20, 2020Iron Contributor
Also, update your version of Office. If you have 365, the latest update should allow you to use Unique function
Helen15
Nov 20, 2020Copper Contributor
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.