Learn LAMBDAs with Spelling Bee
This video shows how to 'solve' the New York Times Spelling Bee, using some of the new LAMBDA helper functions in Excel (MAP, REDUCE, BYROW, and BYCOL).
This is mostly a way to learn some useful Excel techniques - if you find pleasure in solving the puzzle, don't let this spoil that!
You can download the helper file I made in the video here:
https://theexcelements.files.wordpres...
Sections
00:00 Introduction
02:13 Possible words
06:45 Finding all pangrams
11:03 Finding all words
16:40 Hints grid
20:35 Queen Bee! : )
20:47 Explaining the hint formulas
29:17 Alternative all words formula