Forum Discussion

Chris2280's avatar
Chris2280
Copper Contributor
May 06, 2019

Excel SORT() and FILTER() functions are missing

Hello there,   currently i am searching for the SORT() and FILTER() function in excel. I've read that it should be available in Office 365 Pro Plus. But when i am typing in the function into the ce...
excel
Formulas and Functions
office 365
  • BorysBl's avatar
    BorysBl
    Copper Contributor
    Jan 16, 2023
    FILTER function
    Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones
  • Kashif_Masood's avatar
    Kashif_Masood
    Copper Contributor
    Nov 12, 2020

    SergeiBaklan i am isntall  https://insider.office.com/en-us  and not work,

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 12, 2020

      Kashif_Masood 

      Strange, these function are in production now. Could you please share your current version from File->Account, it shall be like

       

  • Chris2280's avatar
    Chris2280
    Copper Contributor
    May 06, 2019

    SergeiBaklan 

     

    Hello Sergei,

     

    thank you for your fast response. Unfortunately the link does not work respectivly does not loading. I tried to access over the google link, but it does not work either. Maybe its just the server. But i will try to install the insider (fast) build und hopefully it works.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 06, 2019

      Chris2280 , strange, it shall work. Try simply insider.office.com or google "Office 365 insider program". Actually this site gives an information about Insiders program and somewhere it shall be instruction how to join and install insiders version - it depends on your platform and are you on personal or business subscription.

      • Daniel_Engler's avatar
        Daniel_Engler
        Copper Contributor
        Sep 14, 2019

        SergeiBaklan 

         

        The Excel SORT function is one of 6 released in July 2019 to build Version 1907 (Build 11901.20176) but I am on a later build (Version 1908 Build 11929.20300) and I still cannot see these new formulas available.

Resources