SOLVED

SAD to log on and lose dynamc formula "=UNIQUE"

%3CLINGO-SUB%20id%3D%22lingo-sub-1414285%22%20slang%3D%22en-US%22%3ESAD%20to%20log%20on%20and%20lose%20dynamc%20formula%20%22%3DUNIQUE%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414285%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I'm%20a%20first%20time%20poster.%20I%20logged%20on%20to%20find%20that%20after%20using%20%22unique%22%20for%20a%20few%20months%20it%20seems%20to%20have%20been%20revoked.%20Let%20me%20set%20the%20scene%2C%20I%20was%20running%202%20systems%3B%20one%20pc%20(64bit)%20and%20one%20laptop%20(32bit).%20I%20had%20set%20up%20some%20beastly%20operations%20making%20use%20of%20the%20new%20UNIQUE%20and%20FILTER%20functions%20and%20it%20worked%20on%20both%20systems.%20I%20ran%20out%20of%20resources%20one%20time%20on%20my%2032bit%20install%20on%20my%20laptop%20and%20so%20decided%20to%20reinstall%20to%20the%2064%20bit%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20having%20reinstalled%20the%2064%20bit%20version%20I%20found%20that%20I%20no%20longer%20had%20the%20UNIQUE%20function.%20Much%20is%20now%20broken%20in%20many%20places%20and%20the%20workbook%20in%20general%20is%20now%20void.%20I%20thought%20that%20the%20unique%20function%20was%20standard%20now%20as%20part%20of%20365%2C%20is%20anyone%20able%20to%20tell%20me%20what%20might%20have%20happened%3F%20There%20is%20no%20way%20I%20can%20do%20what%20I%20was%20doing%20without%20the%20unique%20function%20as%20my%20capacity%20with%20regular%20array%20formulas%20is%20not%20the%20best.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated%20or%20if%20there%20is%20some%20way%20of%20%22reinstating%22%20the%20formula%20that%20would%20be%20grand.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1414285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1414355%22%20slang%3D%22en-US%22%3ERe%3A%20SAD%20to%20log%20on%20and%20lose%20dynamc%20formula%20%22%3DUNIQUE%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414355%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F129904%22%20target%3D%22_blank%22%3E%40Muper%20Sega%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%3C%2FP%3E%0A%3CP%3EThe%20Dynamic%20Array%20functions%20are%20not%20yet%20available%20on%20the%20Semi%20Annual%20Channel%20of%20O365%20so%20it%20sounds%20like%20you%20may%20have%20reverted%20to%20that%20channel%3C%2FP%3E%0A%3CP%3EGo%20to%20File%20%26gt%3B%20Account%20in%20Excel%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheck%20if%20it%20says%20Semi%20Annual%20(attach%20your%20screenshot%20if%20possible)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20531px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F194117iC23F9BD60B3BB1A5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1415355%22%20slang%3D%22en-US%22%3ERe%3A%20SAD%20to%20log%20on%20and%20lose%20dynamc%20formula%20%22%3DUNIQUE%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415355%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20the%20assist%20Wyn%2C%20so%20after%20it%20broke%20on%20my%20laptop%20I%20went%20and%20loaded%20it%20on%20my%20pc%20which%20was%20already%2064bit%20and%20the%20Unique%20formula%20was%20still%20active%20in%20that%20sheet.%20I%20have%20done%20as%20you%20said%20and%20I%20am%20on%20the%20monthly%20channel.%20All%20this%20to%20say%20that%20I%20have%20no%20idea%20what%20happened%2C%20it%20coincided%20with%20me%20forgetting%20my%20password%20and%20one%20drive%20not%20being%20up%20to%20date%2C%20so%20there%20might%20be%20something%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Wyn%2C%20all%20is%20back%20to%20normal%20and%20I%20get%20to%20bathe%20in%20glorious%20dynamic%20formulas%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all, I'm a first time poster. I logged on to find that after using "unique" for a few months it seems to have been revoked. Let me set the scene, I was running 2 systems; one pc (64bit) and one laptop (32bit). I had set up some beastly operations making use of the new UNIQUE and FILTER functions and it worked on both systems. I ran out of resources one time on my 32bit install on my laptop and so decided to reinstall to the 64 bit version.

 

After having reinstalled the 64 bit version I found that I no longer had the UNIQUE function. Much is now broken in many places and the workbook in general is now void. I thought that the unique function was standard now as part of 365, is anyone able to tell me what might have happened? There is no way I can do what I was doing without the unique function as my capacity with regular array formulas is not the best.

 

Any help would be greatly appreciated or if there is some way of "reinstating" the formula that would be grand.

 

Thank you.

2 Replies
Highlighted
Best Response confirmed by Muper Sega (New Contributor)
Solution

@Muper Sega 

 

Hi

The Dynamic Array functions are not yet available on the Semi Annual Channel of O365 so it sounds like you may have reverted to that channel

Go to File > Account in Excel

 

Check if it says Semi Annual (attach your screenshot if possible)

 

image.png

 

 

Highlighted

@Wyn Hopkins 

 

Thank you so much for the assist Wyn, so after it broke on my laptop I went and loaded it on my pc which was already 64bit and the Unique formula was still active in that sheet. I have done as you said and I am on the monthly channel. All this to say that I have no idea what happened, it coincided with me forgetting my password and one drive not being up to date, so there might be something there.

 

Thank you Wyn, all is back to normal and I get to bathe in glorious dynamic formulas again.