Dynamic Arrays — Excel vs Google Sheets

Dynamic arrays work slightly differently in Excel and Google Sheets.

Excel takes care of it automatically.

Read here:
https://support.microsoft.com/en-us/office/dynamic-array-formulas-in-non-dynamic-aware-excel-696e164e-306b-4282-ae9d-aa88f5502fa2

Google Sheets requires =ARRAYFORMULA

Read here:
https://support.google.com/docs/answer/3093275?hl=en