playlistduration

FILTER Array Function Playlist of Videos by excelisfun

by excelisfun · 39 videos

Total watch time

4h 12m

at 1× speed · exactly 4 hours, 11 minutes, 39 seconds at 1×

1×4h 11m 39s
1.25×3h 21m 19s
1.5×2h 47m 46s
1.75×2h 23m 48s
2×2h 5m 50s
Average video6m 27s
Longest17m 3s
Shortest59s
Compare Open on YouTube JSON

Plan to finish

About 5 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 5 days. Turn on JavaScript to plan around your week.

Videos (39)

4h 12m in total · tick what you've watched

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

Videos to
Watched
1 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
2 Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529) 17:03 2018-11-07
3 Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696. 3:56 2020-10-18
4 Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653 3:33 2020-03-25
5 Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669. 6:08 2020-05-16
6 OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743 10:33 2021-07-06
7 One Lookup Value, Return Multiple Items – The Easy Way with FILTER - Excel Magic Trick 1591 1:44 2019-08-19
8 Two Lookup Values for Excel Lookup? FILTER or INDEX? - Excel Magic Trick 1590 2:07 2019-08-17
9 Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits 6:20 2019-04-06
10 Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array). 5:46 2019-02-12
11 FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685. 5:08 2020-08-25
12 OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697. 6:11 2020-10-25
13 IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746 9:05 2021-07-28
14 Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748 6:59 2021-08-10
15 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
16 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752 9:14 2021-09-07
17 Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method - EMT 1776 6:05 2022-03-04
18 XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791 6:59 2022-04-21
19 Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792 12:05 2022-05-31
20 FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799 4:41 2022-10-10
21 FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801 3:24 2022-10-27
22 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 9:47 2023-01-07
23 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819 16:06 2023-02-26
24 Format Total Row in Dynamic Spilled Array (Conditional Formatting) # Short Excel Magic Trick 02 0:59 2023-03-20
25 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820 3:53 2023-04-25
26 Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822 2:54 2023-06-29
27 FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837 6:10 2023-09-03
28 Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function? 4:17 2023-08-25
29 Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836 5:42 2023-08-27
30 Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838. 5:15 2023-09-10
31 FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841 8:29 2023-10-18
32 FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842 3:33 2023-10-25
33 FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843 2:23 2023-11-01
34 Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847 4:30 2024-01-19
35 BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871 6:54 2025-02-26
36 FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874 3:24 2025-03-06
37 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
38 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
39 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13

Embed a badge

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

Watch time: 4h 12m · 39 videos

Markdown
[![Watch time: 4h 12m · 39 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lm44xdS40aBFs7y_8G1DLb.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0lm44xdS40aBFs7y_8G1DLb)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0lm44xdS40aBFs7y_8G1DLb"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lm44xdS40aBFs7y_8G1DLb.svg" alt="Watch time: 4h 12m · 39 videos" width="203" 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/PLrRPvpgDmw0lm44xdS40aBFs7y_8G1DLb 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.