The latest versions of Excel 365 (still in beta release) allow you to define your own functions using spreadsheet formulas within the new LAMBDA function. Working with array formulas is the new 'normal' and there are helper functions that support iteration through the terms of an array.
