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...
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.
By default every file downloaded from the cloud is opened as Read Only, thus you see "Enable editing" if you'd like to edit this file.
Not sure why formula doesn't work, perhaps Excel automatically converted for using in pre-dynamic array Excel. Such conversion is not always correct. Formula shall look as
=TEXTJOIN(",",,IF(B4:J4<>"",IF(MATCH(B4:J4,B4:J4,0)=(COLUMN(B4:J4)-COLUMN(B4)+1),B4:J4,""),""))the only there shall be curve brackets {} around which indicate that is array formula. Be sure no "@" characters are add, if so delete them. Entering the formula use Ctrl+Shift+Enter, not Enter.