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

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