Get instant live expert help on How do I array formula excel mac

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

if I want to write this formula in mac =INDEX({1,2;3,4},0,2) , it does not accept "," as a separator and considers like 1.2 and 3.4 and not an array of 1 2 first row , and 3 4 second row! how can I solve this ?
Solved by F. J. in 16 mins
Need help with SUBSTITUTE in array formula.
Solved by A. S. in 22 mins
Problem with array formula matching on filtering
Solved by M. H. in 22 mins
need review of an ARRAY formula for a complex formula.
Solved by X. F. in 29 mins
I need a formula to copy a cell from a defined array (name ) to another defined array (name) if conditions are satisfied.
Solved by V. A. in 15 mins