Arrays in Excel can be created as follows {“Apple”, “Orange”}
An formula can be converted into a Array Formula by using Ctrl + Shift + Enter
Office 365 can handle array results automatically and so array conversion is not required
Search
Arrays in Excel can be created as follows {“Apple”, “Orange”}
An formula can be converted into a Array Formula by using Ctrl + Shift + Enter
Office 365 can handle array results automatically and so array conversion is not required