Download Excel File: https://excelisfun.net/files/EMT1661.xlsx
Learn Six Methods to extract columns from a table with an Excel Worksheet Formula:
1. (00:01) Introduction
2. (00:13) Formula that works in any version of Excel. INDEX, ROWS and MATCH Functions.
3. (02:10) Office 365 (Microsoft 365) Dynamic Array Formula to extract one column at a time. INDEX and XMATCH Functions.
4. (03:33) Office 365 (Microsoft 365) Dynamic Array Formula to extract entire table with only selected columns. INDEX, SEQUENCE, ROWS and XMATCH Functions.
5. (05:48) Bonus #1: Office 365 (Microsoft 365) Dynamic Array Formula to extract whole table onto a new sheet – Two-Step Method. Table Formula Nomenclature to Spill Dynamic Arrays.
6. (06:35) Bonus #2: Office 365 (Microsoft 365) Dynamic Array Formula to extract whole table onto a new sheet – One-Step Method. Table Formula Nomenclature to Spill Dynamic Arrays.
7. (06:52) Bonus #3: Difference between extract whole table with selected columns as compared to extracting one column at a time. One Column at a time lets us use Spill Operator (Pound Symbol / Hash Tag # ) on individual columns so formulas can spill.
8. (07:50) End Video Links