excel sorting function

%3CLINGO-SUB%20id%3D%22lingo-sub-2170803%22%20slang%3D%22en-US%22%3Eexcel%20sorting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170803%22%20slang%3D%22en-US%22%3E%3CP%3Emy%20excel%20is%20office%202019%20.%20i%20cannot%20see%20sorting%20function%20.%20I%20also%3CFONT%20size%3D%223%22%3E%20cannot%20see%26nbsp%3B%3C%2FFONT%3E%3CFONT%20size%3D%223%22%3EDynamic%20array%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DFILTER(A5%3AD20%2CC5%3AC20%3DH2%2C%22%22%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3ESORTBY()%20-%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2170803%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-2170814%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sorting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F980599%22%20target%3D%22_blank%22%3E%40kt546%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20File%20%26gt%3B%20Account.%20What%20do%20you%20see%20under%20Product%20Information%3F%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%22S0163.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F258629i92961C74EF1AE2D1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0163.png%22%20alt%3D%22S0163.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2170973%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sorting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170973%22%20slang%3D%22en-US%22%3Ealmost%20exactly%20the%20same%20.%20only%20version%20is%202008%20(%20build%2013127.21216%20(%20click%20to%20run)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2171077%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sorting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F980599%22%20target%3D%22_blank%22%3E%40kt546%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks!%20But%20what%20does%20it%20say%20higher%20up.%20In%20the%20screenshot%20that%20I%20posted%2C%20you%20can%20see%20that%20I%20have%20Microsoft%20Office%20Professional%20Plus%202019.%20That%20is%20the%20non-suscription%20version%20which%20does%20not%20get%20new%20features%20such%20as%20the%20FILTER%2C%20SORT%20and%20SEQUENCE%20functions.%20What%20do%20you%20have%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2171425%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sorting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171425%22%20slang%3D%22en-US%22%3Esame%20as%20what%20i%20show%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2171426%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sorting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171426%22%20slang%3D%22en-US%22%3Enow%20i%20lost%20my%20app%20for%20office%20365%20how%20can%20i%20reinstall%20the%20app%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2171445%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sorting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171445%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F980599%22%20target%3D%22_blank%22%3E%40kt546%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOffice%20Professional%20Plus%202019%20does%20not%20have%20the%20new%20functions%20(and%20will%20not%20get%20them)%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20a%20subscription%20to%20Microsoft%20365%20you%20should%20be%20able%20to%20sign%20in%20on%20%3CA%20href%3D%22https%3A%2F%2Fwww.office.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.office.com%3C%2FA%3E%20and%20select%20'Install%20Office'.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2171450%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sorting%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2171450%22%20slang%3D%22en-US%22%3Ewhat%20version%20of%20microsoft%20365%20can%20keep%20update%20the%20new%20version%20of%20office%20i%20cannot%20see%20the%20office%20365%20software%20in%20my%20computer%3C%2FLINGO-BODY%3E
Occasional Contributor

my excel is office 2019 . i cannot see sorting function . I also cannot see Dynamic array

 

=FILTER(A5:D20,C5:C20=H2,""

 

SORTBY() - 

10 Replies

@kt546 

Select File > Account. What do you see under Product Information?

 

S0163.png

almost exactly the same . only version is 2008 ( build 13127.21216 ( click to run)

@kt546 

Thanks! But what does it say higher up. In the screenshot that I posted, you can see that I have Microsoft Office Professional Plus 2019. That is the non-suscription version which does not get new features such as the FILTER, SORT and SEQUENCE functions. What do you have?

same as what i show
now i lost my app for office 365 how can i reinstall the app

@kt546 

Office Professional Plus 2019 does not have the new functions (and will not get them),

 

If you have a subscription to Microsoft 365 you should be able to sign in on https://www.office.com and select 'Install Office'.

what version of microsoft 365 can keep update the new version of office i cannot see the office 365 software in my computer

@kt546 

Your screenshot shows that you currently have Office 2019.

If you want to use the new functions, and if you do not have a subscription to Microsoft 365, you will have to get a subscription. See Compare all Microsoft 365 Products 

have @Hans Vogelaar 

i have download the office365 but i cannot see in my computer with microsft 365 

@kt546 

After downloading, you have to install it.

You should then see Word, Excel etc. in your Start menu,