playlistduration

Excel Extracting Unique Lists / Records Filter or Formulas

by excelisfun · 29 videos

Total watch time

6h

at 1× speed · exactly 5 hours, 59 minutes, 46 seconds at 1×

1×5h 59m 46s
1.25×4h 47m 49s
1.5×3h 59m 51s
1.75×3h 25m 35s
2×2h 59m 53s
Average video12m 24s
Longest54m 46s
Shortest1m 51s
Compare Open on YouTube JSON

Plan to finish

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

Videos (29)

6h 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 660: Advanced Filter Unique Records Only 1:51 2010-07-17
2 Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter 4:02 2010-04-27
3 Excel Magic Trick 1159: Extract Unique List For Data Validation List with Power Query 4:26 2014-11-27
4 Ctrl + Shift + Enter: Excel Array Formulas 20: Extract Unique Lists & Sorting Formulas 54:46 2014-02-13
5 Excel Magic Trick 1252: Power Query To Create Unique List of Invoice Numbers with Balances 4:03 2016-01-12
6 Excel Magic Trick 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature 4:27 2009-09-10
7 Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula) 17:44 2010-01-05
8 Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data) 7:00 2013-08-17
9 Excel Magic Trick 1027: Array Formula To Count Unique Yes Votes For A Given First & Last Name 9:41 2013-07-26
10 Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text 8:58 2013-08-12
11 Excel Magic Trick 1044: Formula To Extract & Sort Unique List Of Numbers Contains Empty Cells & Text 8:30 2013-08-17
12 Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List 17:52 2010-09-03
13 Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range 17:02 2010-12-31
14 Excel Magic Trick 627: FREQUENCY Array Function (10 Examples) 51:50 2010-06-16
15 Excel Magic Trick 690: Extract Unique Records Based on 2 Columns, List Values Horizontally 17:58 2010-11-15
16 Excel Magic Trick #187: Unique List w Dynamic Formula 9:41 2009-01-09
17 Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists 8:08 2008-12-02
18 Excel Magic Trick 251 Formula Unique List within Unique List 8:26 2009-02-04
19 Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records 6:28 2010-04-23
20 Excel Magic Trick #213: Dynamic Data Extract w Formula 9:20 2009-01-19
21 Excel Magic Trick 805: Unique List When Adjacent Cell Contains 1 of 4 Words SEARCH Function & More 11:18 2011-09-16
22 Excel Magic Trick 842: Is Item A Duplicate In Column? Excluding First Occurrence: COUNTIF 2:26 2011-12-15
23 Excel Magic Trick 843: Is Record Duplicate, Excluding First Occurrence? COUNTIFS Function 4:54 2011-12-15
24 Excel Magic Trick 851: Formula To Sum Unique Values In Column 12:04 2012-01-05
25 Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List 14:42 2013-07-24
26 Excel Magic Trick 1053: Unique Count With Criteria: Excel 2013 PivotTable Distinct Count Function 7:17 2013-09-08
27 Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula? 12:38 2016-09-03
28 Excel Magic Trick 1435: DAX Query to Export Data from Data Model to Excel Sheet & Much More! 17:49 2017-05-26
29 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909 4:25 2025-09-29

Embed a badge

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

Watch time: 6h · 29 videos

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