playlistduration

Duplicate Lookup Values - Extract Multiple Items/Records

by excelisfun · 17 videos

Total watch time

2h 43m

at 1× speed · exactly 2 hours, 42 minutes, 34 seconds at 1×

1×2h 42m 34s
1.25×2h 10m 3s
1.5×1h 48m 23s
1.75×1h 32m 54s
2×1h 21m 17s
Average video9m 34s
Longest23m 32s
Shortest2m 21s
Compare Open on YouTube JSON

Plan to finish

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

Videos (17)

2h 43m 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 Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter 23:32 2010-09-03
3 Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods 15:12 2010-12-26
4 Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions 15:06 2010-12-28
5 Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula 8:10 2010-07-22
6 Excel Magic Trick #212: Filter Copy Paste Data Extract 2:21 2009-01-19
7 Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula 12:43 2009-08-13
8 Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula 8:20 2009-08-13
9 Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula 8:24 2009-08-13
10 Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula 10:04 2012-03-30
11 Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through 11:33 2010-03-05
12 Excel 2010 Magic Trick 880: Multiple OR Criteria Using MATCH function For Extracting Data Formula 8:07 2012-03-08
13 Excel Magic Trick 979: 2 Lookup Values in Lookup, Can't Have Helper Column. 7:27 2012-12-15
14 Excel Magic Trick 1005: Lookup nth Duplicate When Column With Lookup Value Is Not Sorted 7:50 2013-06-24
15 Excel Magic Trick 1004: Conditionally Format Row With nth Duplicate, Column Sorted or Not Sorted 6:53 2013-06-24
16 Excel Magic Trick 1003: Lookup nth Duplicate When Column With Lookup Value Is Sorted 2:30 2013-06-24
17 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909 4:25 2025-09-29

Embed a badge

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

Watch time: 2h 43m · 17 videos

Markdown
[![Watch time: 2h 43m · 17 videos](https://playlistduration.com/badge/playlist/PL039C9543F229D9D0.svg)](https://playlistduration.com/playlist/PL039C9543F229D9D0)
HTML
<a href="https://playlistduration.com/playlist/PL039C9543F229D9D0"><img src="https://playlistduration.com/badge/playlist/PL039C9543F229D9D0.svg" alt="Watch time: 2h 43m · 17 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/PL039C9543F229D9D0 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.