playlistduration

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×

1×1h 30m 35s
1.25×1h 12m 28s
1.5×1h 23s
1.75×51m 46s
2×45m 18s
Average video6m 28s
Longest10m 26s
Shortest3m 21s
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.

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.

Videos to
Watched
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

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-09-22 (cached). Private or deleted videos are excluded from totals.