LAMBDA defines the custom logic, and SCAN moves that logic through your data range.
How-To Geek on MSN
How to use the MAP function in Microsoft Excel
Use MAP and LAMBDA to build centralized, error-proof, and auto-spilling Excel spreadsheet systems.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback