Playlist Duration

Playlist · excelisfun

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×

At an hour a day you'd finish in 11 days

The shape of the course

Each column is one video, to scale

1:46:52

WatchedTo watch

Compare Open on YouTube JSON

Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.

Your plan

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. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
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
For your README

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-11-04 (cached). Private or deleted videos are excluded from totals.