Extract Records Based on Partial Text Lookup (Fuzzy Match)

by excelisfun · 7 videos

Total watch time

1h 15m

at 1× speed · exactly 1 hour, 15 minutes, 27 seconds at 1×

custom

1×	1h 15m 27s
1.25×	1h 22s
1.5×	50m 18s
1.75×	43m 7s
2×	37m 44s

Average video10m 47s

Longest20m 54s

Shortest5m 52s

Compare Open on YouTube JSON

Plan to finish

About 2 days at an hour a day

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

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

Videos (7)

1h 15m in total · tick what you've watched

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


1	Excel 2010 Magic Trick 798: Partial Text Lookup Formula To Return Multiple E-mail Records	10:29	2011-09-06
2	Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records	7:30	2011-09-09
3	Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Records	7:40	2011-09-09
4	Excel Magic Trick 1311: Return Multiple Items from One Lookup Value & Show Total for Invoice Items	7:11	2016-07-25
5	Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.	20:54	2016-08-10
6	Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data	15:51	2016-08-17
7	Array Formula: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1595	5:52	2019-08-27

Embed a badge

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

Markdown

[![Watch time: 1h 15m · 7 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0mX-_qU77IMYtLjfrTT2XKS.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0mX-_qU77IMYtLjfrTT2XKS)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0mX-_qU77IMYtLjfrTT2XKS"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0mX-_qU77IMYtLjfrTT2XKS.svg" alt="Watch time: 1h 15m · 7 videos" width="196" 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/PLrRPvpgDmw0mX-_qU77IMYtLjfrTT2XKS 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.