A walkthrough of how to find all the branches of a complex tree using recursive LAMBDAs in Excel - based on a problem from the finals of ModelOff 2013.
You can find all the ModelOff past questions (including this one, which is question 3 from the finals of 2013) here:
https://drive.google.com/drive/folders/1IsojxZw9K8ZbAHwduQiO6pihWFwJ09fu?usp=sharing
You can also find the solution model I built during this video there as well (look in the 'Sample solutions' folder for this round).
00:00 Introduction
05:30 Setup
12:14 One step from one input
14:50 One step from many inputs
22:07 Rewriting to be more efficient
36:09 Multiple steps with recursion
