playlistduration

Excel Data Validation

by excelisfun · 51 videos

Total watch time

6h 17m

at 1× speed · exactly 6 hours, 17 minutes, 22 seconds at 1×

1×6h 17m 22s
1.25×5h 1m 54s
1.5×4h 11m 35s
1.75×3h 35m 38s
2×3h 8m 41s
Average video7m 24s
Longest24m 25s
Shortest46s
Compare Open on YouTube JSON

Plan to finish

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

Videos (51)

6h 17m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Highline Excel 2013 Class Video 28: Excel Data Validation: List, Date, Time, Custom (22 Examples) 24:25 2013-11-08
2 Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet 7:11 2010-03-12
3 Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature? 10:58 2010-03-12
4 Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Dependent DV 6:39 2010-03-12
5 Excel Magic Trick #241: Data Validation w Shrinking List 9:46 2009-02-03
6 Excel Magic Trick 295: DV Dropdown From Diff Workbook 10:43 2009-03-13
7 Excel Magic Trick # 259: Dynamic DV List Based On DV List 5:59 2009-02-12
8 YTLE#58: Data Validation & Excel 2007 Tables 3:15 2008-07-18
9 YTLE#84: A Few Data Validation Tricks 8:23 2008-08-07
10 Excel Magic Trick #123: Date Data Validation 3:43 2008-10-17
11 Excel Magic Trick #177: Data Validation Trouble 4:03 2009-01-03
12 Excel Magic Trick #171: MACRO Data Validation from 3 lists 10:56 2008-12-30
13 Excel Magic Trick # 161: Go To Tricks Complete Story 8:49 2008-12-02
14 Excel Magic Trick 157 Conditional Format Part of Table 3:15 2008-12-02
15 Excel MT 144 p2 Formula: Avoid Data Validations 1 Rule Limit 5:20 2008-10-28
16 Excel MT 144 p1 Formula: Avoid Data Validation 1 Rule Limit 10:33 2008-10-28
17 Excel MT #143: VBA: Avoid Data Validation 1 Rule Limit 4:42 2008-10-28
18 Excel Magic Trick #139: HYPERLINK function & Drop Down List 4:53 2008-10-28
19 Excel Magic Trick #111: Build A Questionnaire 8:02 2008-10-10
20 YouTubersLoveExcel#49: Data Forms 5:48 2008-07-07
21 Excel Magic Trick #94: VLOOKUP Into Web Query 5:18 2008-07-01
22 YouTubersLoveExcel#41: Prevent Duplicates COUNTIF Data Valid 3:09 2008-06-27
23 YouTubersLoveExcel#43: Data Validation & Conditional Format 4:12 2008-06-27
24 Excel Name Trick #7: INDIRECT function, Names and LOOKUP 5:20 2008-06-13
25 Excel Name Trick #5: Names for Pivot Tables & more... 6:54 2008-06-13
26 YouTubersLoveExcel 29 Conditional Formatting & LEFT function 5:15 2008-06-06
27 YouTubersLoveExcel#27: Data Validation From Different Sheet 6:06 2008-06-06
28 YouTubersLoveExcel#17: Hide Bank Rec Formula 10:37 2008-05-23
29 Excel Lookup Series #13: INDEX & MATCH functions Example 3! 10:47 2008-05-01
30 Excel Lookup Series #2: VLOOKUP Function 2nd Example 6:41 2008-04-29
31 Excel Magic Trick #5: Data Validation List & VLOOKUP 4:16 2008-03-03
32 Excel Magic Trick 324: Dynamic Data Validation List of Dates 7:31 2009-05-17
33 Excel Magic Trick 387: Data Validation Drop-Down List & Cell References 2:49 2009-09-17
34 Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Down 7:22 2009-10-08
35 Excel Magic Trick 412: Data Validation Drop Down List & OFFSET function 4:13 2009-10-14
36 Excel Magic Trick 593: Mondays Only Data Validation using Custom Formula with WEEKDAY function 4:03 2010-05-07
37 Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List 17:52 2010-09-03
38 Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together 10:29 2011-03-30
39 Excel Magic Trick 830: No Duplicates Allowed In Row, Data Validation Custom Logic Formula COUNTIF 4:26 2011-12-04
40 Excel Magic Trick 895: Entered Date Must Be Greater or Equal to Any Dates Above Data Validation 3:13 2012-03-30
41 Excel Magic Trick 916: Remove Blanks In Data Validation Drop Down List 5 Examples 23:58 2012-05-10
42 Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List 14:42 2013-07-24
43 Excel Magic Trick 1125: Data Validation Custom Formula: Workday Dates in Current Month 8:21 2014-06-26
44 Excel Magic Trick 1159: Extract Unique List For Data Validation List with Power Query 4:26 2014-11-27
45 Excel Magic Trick 1502: Lookup Based On Row Number with Data Validation For Row Number 8:21 2018-06-09
46 Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523 4:46 2018-11-01
47 Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740 11:18 2021-06-14
48 Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773 2:48 2022-01-28
49 Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71 0:46 2025-03-13
50 Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878 2:35 2025-03-14
51 Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910 7:25 2025-10-01

Embed a badge

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

Watch time: 6h 17m · 51 videos

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