Excel vs Google Sheets: ARRAYFORMULA Compatibility | ComTools
Compare ARRAYFORMULA on Excel (Not supported) vs Google Sheets (Supported). Alternatives and free conversion.
Side-by-side support
Excel: Not supported. Google Sheets: Supported. Sheets alternative: —. Excel alternative: Dynamic arrays / CSE.
Migration tip
Excel 365 spills dynamically; legacy Excel used Ctrl+Shift+Enter arrays.
Convert now
Use /excel-formula-converter?fn=arrayformula to paste a formula containing ARRAYFORMULA.
FAQ
QCan I use ARRAYFORMULA on both platforms?
Not fully. Use the alternatives listed above or the online converter for suggestions.