Forum Discussion

Copper Contributor

May 23, 2020

Solved

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

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 la...

excel

Formulas and Functions

office 365

Wyn Hopkins
May 23, 2020
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)

Wyn Hopkins

MVP

May 23, 2020

Muper Sega

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)

Muper Sega
Copper Contributor
May 24, 2020
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.