Excel LAMBDA: MAP function in under 3 minutes

Here's a very quick introduction to the MAP function in Excel.

Use it to lift scalar functions over arrays.

#excel #exceltips #exceltutorial #analysis #tutorial

[Fxingenieria]

Thank you, excellent explanation of MAP.

[sunnybaggu]

Thank you for the looking forward for your dynmic arrays content

[abbottkatz]

This formula also seems to work: =BYROW(A2:B6, LAMBDA(a, OR(a="a", a="a")))

[dimamedvedev]

Great explanation. But why copy formula in each cell in second example is bad?

[abbottkatz]

another emulation of MAP in this case:
=(A2:A6="a")+(B2:B6="a")>0