Three more of the new Lambda Helper functions in Excel: MAP, REDUCE, and SCAN. In today’s episode, see three different ways to create a PRODUCTIF function in Excel using MAP, REDUCE, or SCAN.
Important points:
MAP can take one or more arrays.
MAP is looking at each individual cell, not just the values in the cells.
REDUCE does the same thing, but produces a single result.
SCAN is like REDUCE, but makes the intermediate results available.
Read more at: https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-helper-functions-lambdas-as-arguments-and-more/bc-p/2587253#M2240