Playlist Duration

Playlist · Leila Gharani

Drop Down Lists in Excel (Dependent, Unique Lists and other data validation lists)

by Leila Gharani · 13 videos

Total watch time

2h 34m

at 1× speed · exactly 2 hours, 33 minutes, 31 seconds at 1×

At an hour a day you'd finish in 3 days

The shape of the course

Each column is one video, to scale

11:44
8:46
7:54
7:25
14:49
19:18
15:42
14:16
15:55
7:01
12:56
5:48
11:57

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 3 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 3 days. Turn on JavaScript to plan around your week.

Videos (13)

2h 34m 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 How to Create a Dependent Drop Down Lists in Excel (with OFFSET, CHOOSE, INDEX & INDIRECT) 11:44 2017-03-23
2 Create Dynamic Drop-Down Lists Based on Numbers Using INDEX (without MATCH) in Excel 8:46 2017-03-15
3 Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List 7:54 2017-11-01
4 Excel Dependent Drop Down List with Tabular Data without Named Ranges 7:25 2017-11-08
5 Extract UNIQUE Items for Dynamic Data Validation Drop Down List 14:49 2018-01-03
6 Find Multiple Matches & Dependent Drop Down List in Excel (Unsorted Tabular Data Set) 19:18 2018-03-15
7 Create SMART Drop Down Lists in Excel (with Data Validation) 15:42 2018-05-10
8 Excel Custom Data Validation (Use formulas to check for text, numbers & length) 14:16 2018-05-24
9 Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells 15:55 2018-07-19
10 Excel Dynamic Arrays (How they will change EVERYTHING!) 7:01 2018-10-18
11 This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this) 12:56 2018-12-06
12 Reset Dependent Drop-down in Excel (with a tiny bit of VBA) 5:48 2018-12-13
13 Create Multiple Dependent Drop-Down Lists in Excel (on Every Row) 11:57 2020-03-26
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: 2h 34m · 13 videos

Markdown
[![Watch time: 2h 34m · 13 videos](https://playlistduration.com/badge/playlist/PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y.svg)](https://playlistduration.com/playlist/PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y)
HTML
<a href="https://playlistduration.com/playlist/PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y"><img src="https://playlistduration.com/badge/playlist/PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y.svg" alt="Watch time: 2h 34m · 13 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/PLmHVyfmcRKywYhC1Q9eZqR7D-_cdiwl6y 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.