Download Excel File: https://excelisfun.net/files/EMT1654.xlsx
Learn how to extract the last “n” records to a table, including if we add a new columns using the INDEX and SEQUENCE Functions and Table Formula Nomenclature for Table Field Names. Thanks to Bill Szysz for this cool formula.
1. (00:01) Introduction.
2. (00:19) Formula #1: INDEX function to lookup values. ROWS and SEQUENCE for row numbers and Array Constant for column numbers.
3. (02:16) Conditional Formatting for Spilled Arrays. Logical Formula for “Not Equal to Nothing”.
4. (03:04) Formula #2: INDEX function to look values. ROWS and SEQUENCE for row numbers and SEQUENCE, COLUMNS and Table Formula Nomenclature for Column Headers for columns numbers.
5. (03:40) Table Formula Nomenclature for extracting Dynamic List of Column Headers.
6. (04:02) Summary and End Video Links.