Playlist Duration

Playlist · excelisfun

Excel Formulas To Lookup Last Item In A Column Palylist

by excelisfun · 14 videos

Total watch time

1h 31m

at 1× speed · exactly 1 hour, 30 minutes, 35 seconds at 1×

The shape of the course

Each column is one video, to scale

10:24
4:29
4:35
3:21
6:44
4:09
8:09
6:50
6:51
10:26
4:04
7:24
7:17
5: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 2 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 2 days. Turn on JavaScript to plan around your week.

Videos (14)

1h 31m 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 Magic Trick 454: Get Last Number or Word or Anything 4 Amazing LOOKUP functions 10:24 2009-12-01
2 Excel Magic Trick 541: Get Last Price In Column Based On Criteria In Other Columns 4:29 2010-03-12
3 Excel Magic Trick 844: Last Date In Column A For "N" In Column B 4:35 2011-12-15
4 Excel Magic Trick 987: LOOKUP Last Number In Column, Excluding Zeroes 3:21 2013-01-22
5 Excel Magic Trick 984: Lookup Penultimate: Get Second To Last Item From Column Of Mixed Data 6:44 2013-01-10
6 Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions 4:09 2013-06-13
7 Excel Magic Trick 983: Get Last Data For Employee From Across Many Sheets 8:09 2013-01-08
8 Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range 6:50 2012-11-08
9 Excel Magic Trick 942: Lookup Last Shipment Date For Customer, Sorted & Not Sorted Date Column 6:51 2012-07-06
10 Excel Magic Trick 938: Lookup Row Associated With Employee And Get Last In That Row 10:26 2012-07-02
11 Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number 4:04 2011-04-01
12 Mr Excel & excelisfun Trick 70: Lookup & Return Last 5 Numbers in a List 7:24 2011-03-11
13 Mr Excel & excelisfun Trick #6: Get Last Value In Row 7:17 2009-04-17
14 Excel Magic Trick #134: Find Last Value In List 5:52 2008-10-28
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: 1h 31m · 14 videos

Markdown
[![Watch time: 1h 31m · 14 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lmMHR2YFf0xp7cJb_AxMRc.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0lmMHR2YFf0xp7cJb_AxMRc)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0lmMHR2YFf0xp7cJb_AxMRc"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lmMHR2YFf0xp7cJb_AxMRc.svg" alt="Watch time: 1h 31m · 14 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/PLrRPvpgDmw0lmMHR2YFf0xp7cJb_AxMRc returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-11-06 (cached). Private or deleted videos are excluded from totals.