playlistduration

Dynamic Spilled Array Formulas & Functions: Revolution in Easier Worksheet Solutions

by excelisfun · 33 videos

Total watch time

10h 54m

at 1× speed · exactly 10 hours, 54 minutes, 1 second at 1×

1×10h 54m 1s
1.25×8h 43m 13s
1.5×7h 16m 1s
1.75×6h 13m 43s
2×5h 27m 1s
Average video19m 49s
Longest1h 46m 52s
Shortest1m 8s
Compare Open on YouTube JSON

Plan to finish

About 11 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 11 days. Turn on JavaScript to plan around your week.

Videos (33)

10h 54m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Dynamic Spilled Array Formulas & Functions: 50 Examples to Become an Expert! - 365 MECS 09 1:10:10 2022-11-20
2 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752 9:14 2021-09-07
3 Excel 365 Basics #7: Comprehensive Formula & Function Lesson To Become An Excel Formula Guru! 1:26:24 2025-01-06
4 MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total 3:28 2025-04-13
5 MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve! 6:14 2025-04-09
6 MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples! 51:23 2025-03-30
7 Excel 365 Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task! 49:21 2024-12-22
8 Excel 365 Basics #5: IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More 46:45 2024-12-12
9 DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples. 52:18 2024-05-05
10 Append Tables in Excel. Excel Magic Trick 1852 1:08 2024-02-19
11 Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10 1:46:52 2024-01-03
12 ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846 2:29 2023-11-19
13 FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837 6:10 2023-09-03
14 Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21 15:49 2023-06-18
15 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820 3:53 2023-04-25
16 Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818 6:04 2023-02-24
17 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786 6:29 2022-03-25
18 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
19 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
20 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
21 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716 4:52 2021-01-13
22 Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683. 7:59 2020-08-17
23 Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669. 6:08 2020-05-16
24 INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668. 5:11 2020-05-13
25 Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898 8:20 2025-06-22
26 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
27 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901 24:46 2025-08-15
28 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908 7:43 2025-09-16
29 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909 4:25 2025-09-29
30 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
31 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13
32 2 Excel Formulas to Add Sequential Numbers Each Time a New Row Is Added To a Table. EMT 1915 5:09 2025-11-11
33 Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922. 10:54 2026-02-03

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 10h 54m · 33 videos

Markdown
[![Watch time: 10h 54m · 33 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0mMuGB1MbPOJhLJ9ah342CY.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0mMuGB1MbPOJhLJ9ah342CY)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0mMuGB1MbPOJhLJ9ah342CY"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0mMuGB1MbPOJhLJ9ah342CY.svg" alt="Watch time: 10h 54m · 33 videos" width="210" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0mMuGB1MbPOJhLJ9ah342CY returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.