Completed
min) OFFSET function to create dynamic range formula.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions
Automatically move to the next video in the Classroom when playback concludes
- 1 min) Dynamic Range: A range that you can use in a formula, chart, PivotTable, etc. that can expand or contract when you add data.
- 2 min) INDEX & OFFSET functions can return a range of cells (a type of array) that can be used in formulas, charts & other locations that expect a reference.
- 3 min) INDEX function to lookup a range (row or column).
- 4 min) If there is no "Array Operation" (math, comparative, join, function argument) in INDEX formula used to create range, Ctrl + Shift + Enter is not required.
- 5 min) Excel Table feature.
- 6 min) Reasons you might not want to use Excel Table feature.
- 7 min) Defined Names.
- 8 min) Keyboards for Defined Names.
- 9 min) INDEX to create Defined Name dynamic range formula for text data in column (4 Examples).
- 10 min) INDEX to create Defined Name dynamic range formula for number data in column.
- 11 min) INDEX to create Defined Name dynamic range formula for mixed data in column.
- 12 min) INDEX to create Defined Name dynamic range formula for rectangular range (3 examples).
- 13 min) VLOOKUP and Data Validation List with Defined Name Dynamic Ranges.
- 14 min) Define Name dynamic range formula that can handle an extra space below the data.
- 15 min) OFFSET function to create dynamic range formula.
- 16 min) Defined Name dynamic range formula For Chart.
- 17 min) Dynamic range based on criteria from drop-down list INDEX and OFFSET.
- 18 min) INDEX or OFFSET for dynamic range formulas?
- 19 min) Recalculation time in Excel.
- 20 min) Add last 5 list with SUM function and Dynamic Range.
- 21 min) SUMIF, SUMIFS, COUNTIF and similar functions can handle dynamic ranges created by INDEX function.
