Playlist · excelisfun
Excel Remove Duplicates Videos
Total watch time
1h
at 1× speed · exactly 1 hour, 7 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 2 days 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 2 days. 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 (9)
1h 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 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature | 4:27 | 2009-09-10 | ||
| 2 | YTLE#55: Excel 2007 Remove Duplicates and COUNTIF function | 2:30 | 2008-07-14 | ||
| 3 | YTLE#54: Excel Advanced Filter and COUNTIF function | 3:09 | 2008-07-14 | ||
| 4 | YTLE#53: Excel Pivot Table and COUNTIF function | 3:26 | 2008-07-14 | ||
| 5 | Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range | 17:02 | 2010-12-31 | ||
| 6 | Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List | 14:42 | 2013-07-24 | ||
| 7 | Excel Dynamic Array UNIQUE with INDIRECT To Extract Unique Lists for Each Column (EMT 1522) | 4:05 | 2018-10-26 | ||
| 8 | Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523 | 4:46 | 2018-11-01 | ||
| 9 | Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column | 6:00 | 2019-02-13 |
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/PL9E31A22E3B6DB6CF)<a href="https://playlistduration.com/playlist/PL9E31A22E3B6DB6CF"><img src="https://playlistduration.com/badge/playlist/PL9E31A22E3B6DB6CF.svg" alt="Watch time: 1h · 9 videos" width="168" 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/PL9E31A22E3B6DB6CF returns them as JSON — free, no key. API docs →
Data from the YouTube Data API as of 2026-11-05 (cached). Private or deleted videos are excluded from totals.