Forum Discussion

Soumalya Biswas's avatar
Soumalya Biswas
Copper Contributor
May 03, 2019

Dynamic Arrays not available in Office 365

I am an Office 365 Subscriber and an Office Insider too, what happened suddenly that I am not able to use the Dynamic Array functions like Sort, Sortby, Randarray ? the Excel 365 behaves like the older one, I have the latest updates too.

  • Soumalya Biswas , from you screenshort it's not clear do you really have no DA functions or not. If to enter such way any other, let say =if, you also have same error.

     

    When you start typing, e.g. =sor, do you see SORT and SORTBY in the list of suggested functions?

    • Lanreezy's avatar
      Lanreezy
      Copper Contributor

      I do see those functions, yet can't use dynamic array.

    • Soumalya Biswas's avatar
      Soumalya Biswas
      Copper Contributor

      When i was typing and looking for sort, sortby, sequence, randarray i wasnt getting them but after several fresh installations and sigin it finally workedSergeiBaklan 

Resources