Playlist · excelisfun
Excel Tricks For Items In Succession In A Column
Total watch time
28m 55s
at 1× speed · exactly 28 minutes, 55 seconds at 1×
The shape of the course
Each column is one video, to scale
WatchedTo watch
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 1 day 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 1 day. Turn on JavaScript to plan around your week.
How do I import this?
Google Calendar: in the left sidebar, + beside Other calendars → Import → pick the downloaded .ics → choose a calendar → Import. The same menu's From URL subscribes to the feed instead.
Apple Calendar (Mac): double-click the file or drag it onto Calendar → choose a calendar → Add all.
iPhone / iPad: open the file from Files, Mail or Safari's download bar → Add All → choose a calendar.
Outlook, Android, and subscribing instead of importing: step by step for every app →
Videos (4)
28m 55s 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.
| Watched | Leave out of the total | ||||
|---|---|---|---|---|---|
| 1 | Excel Magic Trick 713: Count Max Number In Succession in Column FREQUENCY function magic! | 5:37 | 2010-09-03 | ||
| 2 | Excel Magic Trick 959: Start Position Of Most Consecutive Ones, Single Cell Array Formula Method | 15:54 | 2012-08-03 | ||
| 3 | Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808 | 4:39 | 2022-12-12 | ||
| 4 | Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts | 2:45 | 2023-01-16 |
No videos match that filter.
For your README
Embed a badge
Show the watch time in a README or course description — it links back here and updates itself
[](https://playlistduration.com/playlist/PLrRPvpgDmw0nxzWkOdcMqCeGJZ9MMcAuE)<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nxzWkOdcMqCeGJZ9MMcAuE"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nxzWkOdcMqCeGJZ9MMcAuE.svg" alt="Watch time: 28m 55s · 4 videos" width="202" 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/PLrRPvpgDmw0nxzWkOdcMqCeGJZ9MMcAuE returns them as JSON — free, no key. API docs →
Data from the YouTube Data API as of 2026-11-09 (cached). Private or deleted videos are excluded from totals.