4 ms·
Exactly. I’m not sure what to call the new feature, “array spillage”? I didn’t know the original was called “array formulas”. Anyway, the change to make the out
by wrs 3y ago
Exactly. I’m not sure what to call the new feature, “array spillage”? I didn’t know the original was called “array formulas”. Anyway, the change to make the output go into cells automatically is indeed what I meant.
- mr_toad 3y agoIn a programming language it would be called destructuring.
- Izkata 3y agoYour link calls them "multi-cell array formulas" (expand the first accordion).
- bhl 3y agoYeah, 'spilled array' and 'spilling' are the correct noun and verb. https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531 https://support.microsoft.com/en-us/office/dynamic-array-for...