playlistduration

Excel Tricks For Items In Succession In A Column

by excelisfun · 4 videos

Total watch time

28m 55s

at 1× speed · exactly 28 minutes, 55 seconds at 1×

1×28m 55s
1.25×23m 8s
1.5×19m 17s
1.75×16m 31s
2×14m 28s
Average video7m 14s
Longest15m 54s
Shortest2m 45s
Compare Open on YouTube JSON

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.

Days

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

Videos (4)

28m 55s 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 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

Embed a badge

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

Watch time: 28m 55s · 4 videos

Markdown
[![Watch time: 28m 55s · 4 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nxzWkOdcMqCeGJZ9MMcAuE.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0nxzWkOdcMqCeGJZ9MMcAuE)
HTML
<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-09-22 (cached). Private or deleted videos are excluded from totals.