MicrosoftThis is awesome news, Chris_Gross
The golden trio: FILTER, MAP, REDUCE is finally coming to the Excel.
MAKEARRAY
Maybe it's better to add lambda as an optional parameters to SEQUENCE()? If not then rename it to just ARRAY()?
MAP, REDUCE, FILTER
Maybe it's better to add Add BYCOL and BYROW as an optional parameters? If omitted than go 1 by 1 left-bottom.
ISOMITED
Maybe it's better to change the logic to ISPRESENT? Most of the time optional parameter supposed to be not provided, I think it's logically more correct to check if it's present rather than it's not.
Can optional parameter also be set to default parameter initially? LAMBDA(A = 1; B).
SCAN
Not sure if this name is sound. AFAIU the only difference between MAP and SCAN is that SCAN can work with not only current value of an array but also with a previous one.
In doc example =SCAN("",A1:C2,LAMBDA(a,b,a&b)) a,b means current and previous one.
So maybe it's better to harmonize both functions into 1: MAP.
Overall, this is really great news, well done!
