Playlist Duration

Playlist · excelisfun

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×

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

The shape of the course

Each column is one video, to scale

23:32

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

Videos to
Watched Leave out of the total
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
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: 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-11-03 (cached). Private or deleted videos are excluded from totals.