Forum Discussion
Soumalya Biswas
May 03, 2019Copper Contributor
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?
- LanreezyCopper Contributor
I do see those functions, yet can't use dynamic array.
- Soumalya BiswasCopper 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