playlistduration

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×

1×2h 33m 31s
1.25×2h 2m 49s
1.5×1h 42m 21s
1.75×1h 27m 43s
2×1h 16m 46s
Average video11m 49s
Longest19m 18s
Shortest5m 48s
Compare Open on YouTube JSON

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.

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

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