LET and LAMBDA - getting started with the two best functions in modern Excel

An introduction to using the two best functions in modern Excel: LET and LAMBDA.

The problem is Battle 7 from the @FMWC Road to Las Vegas. If you want to give it a go, it's on sale here:

[DimEarly]

When I recorded this, I went on to tackle level 5 and bonus 3, but then decided to cut that out to keep this video more approachable. But then I decided it was a shame to waste that, so I uploaded a separate (unlisted) 'director's cut' with the bits I left out. You can find it here if you're interested:

[harryseiders]

Great video! I always thought that reduce needed the word lambda in the third argument

[ExcelWizard]

13:00 The Final formula is beautiful 😍

[vikhattangady]

Thanks for the great video. I did not notice how you calculated your offsets depending on whether the ball started with a Red or Blue player.
In my case, I set up the offset calc basis a red player, and then had an additional multiplier of -1 for the offsets if the LEFT(player name)="B"

[DrKazza]

@DimEarly - any chance you could do a video going through the different use cases for "Reduce" "Scan" and "Map", I'm still confused about when to use each one - Cheers

[ValyGreavu]

I am very currious about your way to solve bonus 2 question of this case. Thank you!

[matteo.gerardo]

could you make a video applying this to a financial model?