Excel vs Google Sheets: MAKEARRAY Compatibility | ComTools
Compare MAKEARRAY on Excel (Supported) vs Google Sheets (Not supported). Alternatives and free conversion.
Side-by-side support
Excel: Supported. Google Sheets: Not supported. Sheets alternative: ARRAYFORMULA. Excel alternative: —.
Migration tip
MAKEARRAY: Excel=Supported, Sheets=Not supported.
Convert now
Use /excel-formula-converter?fn=makearray to paste a formula containing MAKEARRAY.
FAQ
QCan I use MAKEARRAY on both platforms?
Not fully. Use the alternatives listed above or the online converter for suggestions.