skinny.

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…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.