How to Create a Dynamic Array - SEQUENCE Function
A dynamic table in Excel is a table where formulas will automatically display based on the values of one or more parameters.
00:00 Introduction
00:43 Keeping only the first line of a formula
01:17 The SEQUENCE function returns a dynamic list
01:40 Adapting existing formulas with SEQUENCE
02:59 Extended references with hash marks
04:18 Dynamic addition with hash marks
04:40 Conditional formatting
06:48 Making an existing table dynamic
09:14 Conclusion