Dynamic Arrays not available in Office 365

Copper Contributor

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.

2 Replies

@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?

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