Feb 27 2021 02:21 AM
my excel is office 2019 . i cannot see sorting function . I also cannot see Dynamic array
=FILTER(A5:D20,C5:C20=H2,""
SORTBY() -
Feb 27 2021 02:26 AM
Feb 27 2021 05:00 AM
Feb 27 2021 06:45 AM
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?
Feb 27 2021 09:16 AM
Feb 27 2021 09:40 AM
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'.
Feb 27 2021 09:49 AM
Feb 27 2021 10:59 AM
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
Feb 27 2021 06:49 PM
have @Hans Vogelaar
i have download the office365 but i cannot see in my computer with microsft 365
Feb 28 2021 01:18 AM
After downloading, you have to install it.
You should then see Word, Excel etc. in your Start menu,