Forum Discussion
kt546
Feb 27, 2021Copper Contributor
excel sorting function
my excel is office 2019 . i cannot see sorting function . I also cannot see Dynamic array =FILTER(A5:D20,C5:C20=H2,"" SORTBY() -
HansVogelaar
Feb 27, 2021MVP
- kt546Feb 27, 2021Copper Contributoralmost exactly the same . only version is 2008 ( build 13127.21216 ( click to run)
- HansVogelaarFeb 27, 2021MVP
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?
- kt546Feb 27, 2021Copper Contributorsame as what i show