3 ms·

I believe the OP is referring to array formulas which effectively explode the results into multiple cells, which was introduced in 2018.

• 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 ago
    In a programming language it would be called destructuring.
  • Izkata 3y ago
    Your link calls them "multi-cell array formulas" (expand the first accordion).
  • bhl 3y ago
    Yeah, '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...