There are array formulas: https://support.microsoft.com/en-us/office/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7 https://sup

There are array formulas: https://support.microsoft.com/en-us/office/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7 https://support.microsoft.com/en-us/office/guidelines-and-ex... There have actually been a couple of tries at them. The modern “dynamic” array formulas are a little less fiddly.