Latest / ModeLoop: Financial Modelling in Excel

Excel dynamic arrays: FILTER, SORT, UNIQUE and LET
Spilled formulas need clear inputs and edge-case rules. Follow a small financial-modelling project table.
Financial Modelling with AI: Part 3, lesson 7.
In this episode:
- Use UNIQUE and SUMIFS with explicit duplicate logic.
- Check FILTER thresholds and sorted views.
- Handle missing or invalid inputs with LET and IF.
Watch the companion video: https://www.youtube.com/watch?v=7tPByL02M_c
Read the lesson: https://modeloop.net/Blog/P3E7-AI-in-Financial-Modelling-Dynamic-Arrays-with-AI-FILTER-SORT-UNIQUE-and-LET
AI in Financial Modelling course…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.