Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661

excelisfun
1.24M subscribers
43K views 5 years ago
Download Excel File: https://excelisfun.net/files/EMT1661.... 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 ...more
...more

1..Introduction

0:01

2..Formula that works in any version of Excel. INDEX, ROWS and MATCH Functions.

0:13

3..Office 365 (Microsoft 365) Dynamic Array Formula to extract one column at a time. INDEX and XMATCH Functions.

2:10

4..Office 365 (Microsoft 365) Dynamic Array Formula to extract entire table with only selected columns. INDEX, SEQUENCE, ROWS and XMATCH Functions.

3:33

5..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.

5:48

6..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.

6:35

7..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.

6:52

8..End Video Links

7:50
Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661
1KLikes
43,964Views
2020Apr 23
Download Excel File: https://excelisfun.net/files/EMT1661.... 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
How this content was made
Auto-dubbed
Audio tracks for some languages were automatically generated. Learn more

Follow along using the transcript.

excelisfun

1.24M subscribers