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 ☺️
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.
- I'm even more confused, when I open up your file it does only show unique email address but at the top of excel it says " Protected view: Be careful - files from the internet can contain viruses. Unless you need to edit, it's safer to stay in protected view" then there is a button to press which says "Enable Editing". As i need to enable editing i click on the button and then the formula doesn't work as they go back to a list and not unique email address. Is there some sort of excel option that i need to tick to let this formula work? Many thanks in advance.