Missing FILTER, SORT and UNIQUE functions

%3CLINGO-SUB%20id%3D%22lingo-sub-1497258%22%20slang%3D%22en-US%22%3EMissing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497258%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20office%20365%20Business%20and%20I%20have%20noticed%20an%20hour%20ago%20that%20some%20functions%20like%20Filter%2C%20Sort%20and%20Unique%20are%20missing.%20Anyone%20know%20the%20reason%3F%20I%20used%20them%20couple%20days%20ago%2C%20but%20now%20they%20are%20gone%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1497258%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497933%22%20slang%3D%22en-US%22%3ERE%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497933%22%20slang%3D%22en-US%22%3ETry%20going%20to%20File%20Tab%20%26gt%3B%26gt%3B%20Accounts%20%26gt%3B%26gt%3B%20Office%20Update%20Check%20for%20updates%20and%20install%20them%20if%20any%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498181%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498181%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713768%22%20target%3D%22_blank%22%3E%40Zarko_Tripunovic%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20on%20which%20channel%20you%20are%20in%20File-%26gt%3BAccount.%20If%20on%20semi-annual%20that%20could%20be%2C%20dynamic%20arrays%20shall%20be%20on%20it%20somewhere%20in%20July.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498228%22%20slang%3D%22en-US%22%3ERE%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498228%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3Bthanks%20for%20Your%20response.%20Updated%20but%20still%20nothing%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498231%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498231%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthanks%20for%20Your%20help%2C%20but%20that%20is%20not%20problem.%20My%20colleague%20has%20the%20same%20version%20and%20he%20has%20all%20new%20function.%20Only%20thing%20that%20I%20didn't%20try%20is%20to%20uninstall%20and%20install%20it%20again.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498254%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498254%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713768%22%20target%3D%22_blank%22%3E%40Zarko_Tripunovic%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20not%20uncommon%20because%20Microsoft%20keeps%20making%20frequent%20changes%20and%20spreading%20these%20changes%20randomly%20to%20users.%20You%20might%20be%20among%20the%20lucky%20people%20who%20get%20it%20first%20and%20you%20might%20not...%20But%20rest%20assured%2C%20it's%20just%20a%20matter%20of%20time%20and%20you'll%20get%20the%20full%20functionality%20back...%20and%20much%20more%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498259%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498259%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20was%20weird%20for%20me%20because%20my%20colleague%20has%20same%20Office%20365%20and%20he%20has%20it%20and%20I%20don't.%20I%20uninstalled%20Office%20and%20installed%20it%20again%20and%20now%20I%20have%20these%20functions%20again.%20Once%20again%2C%20thank%20You%20for%20Your%20time%20and%20support.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498263%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498263%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%20Hey%20I%20just%20noticed%20that%20You%20have%20YT%20channel%26nbsp%3B%3CSPAN%3EOfficeinstructor.%20I'm%20big%20fan%20and%20You%20have%20great%20videos.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498284%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713768%22%20target%3D%22_blank%22%3E%40Zarko_Tripunovic%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERe-installation%20and%20update%20not%20necessary%20could%20help.%20New%20functionality%20code%20is%20already%20within%20your%20build%2C%20and%20it%20switching%20on%2Foff%20by%20licensing%20engine%20when%20you%20are%20online.%20However%2C%20dynamic%20arrays%20shall%20be%20available%20for%20everyone%20on%20current%20channel.%20I'd%20recommend%20to%20open%20support%20ticket%20or%20at%20least%20Send%20a%20Frown%20through%20File-%26gt%3BFeedback.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498294%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498294%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bi%20did%20re-installation%20of%20Office%20and%20it%20works%20just%20fine%20now.%20Thank%20You%20very%20much%20for%20Your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498296%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498296%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713768%22%20target%3D%22_blank%22%3E%40Zarko_Tripunovic%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGlad%20your%20issue%20is%20resolved%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20a%20pleasure%20to%20see%20you%20here%20and%20on%20my%20YouTube%20Channel...%3C%2FP%3E%0A%3CP%3EStay%20tuned...%20The%20Best%20Is%20Yet%20To%20Come%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498297%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20FILTER%2C%20SORT%20and%20UNIQUE%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713768%22%20target%3D%22_blank%22%3E%40Zarko_Tripunovic%3C%2FA%3E%26nbsp%3B%2C%20glad%20to%20know%20you%20sorted%20this%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

 

I have office 365 Business and I have noticed an hour ago that some functions like Filter, Sort and Unique are missing. Anyone know the reason? I used them couple days ago, but now they are gone

11 Replies
Highlighted
Try going to File Tab >> Accounts >> Office Update Check for updates and install them if any
Highlighted

@Zarko_Tripunovic 

Please check on which channel you are in File->Account. If on semi-annual that could be, dynamic arrays shall be on it somewhere in July.

Highlighted

@nabilmourad thanks for Your response. Updated but still nothing

Highlighted

@Sergei Baklan thanks for Your help, but that is not problem. My colleague has the same version and he has all new function. Only thing that I didn't try is to uninstall and install it again. 

Highlighted

@Zarko_Tripunovic 

It's not uncommon because Microsoft keeps making frequent changes and spreading these changes randomly to users. You might be among the lucky people who get it first and you might not... But rest assured, it's just a matter of time and you'll get the full functionality back... and much more

Highlighted

@nabilmourad 

It was weird for me because my colleague has same Office 365 and he has it and I don't. I uninstalled Office and installed it again and now I have these functions again. Once again, thank You for Your time and support.

Highlighted

@nabilmourad  Hey I just noticed that You have YT channel Officeinstructor. I'm big fan and You have great videos.

Highlighted

@Zarko_Tripunovic 

Re-installation and update not necessary could help. New functionality code is already within your build, and it switching on/off by licensing engine when you are online. However, dynamic arrays shall be available for everyone on current channel. I'd recommend to open support ticket or at least Send a Frown through File->Feedback.

Highlighted

@Sergei Baklan i did re-installation of Office and it works just fine now. Thank You very much for Your help.

Highlighted

@Zarko_Tripunovic 

Glad your issue is resolved  

It's a pleasure to see you here and on my YouTube Channel...

Stay tuned... The Best Is Yet To Come

Highlighted

@Zarko_Tripunovic , glad to know you sorted this out.