playlistduration

Excel Count Unique Items in List, or Distinct Count

by excelisfun · 13 videos

Total watch time

3h 15m

at 1× speed · exactly 3 hours, 15 minutes, 18 seconds at 1×

1×3h 15m 18s
1.25×2h 36m 14s
1.5×2h 10m 12s
1.75×1h 51m 36s
2×1h 37m 39s
Average video15m 1s
Longest51m 50s
Shortest3m 56s
Compare Open on YouTube JSON

Plan to finish

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

Videos (13)

3h 15m in total · tick what you've watched

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

Videos to
Watched
1 Ctrl + Shift + Enter: Excel Array Formulas 18: Unique Count Formulas: FREQUENCY or COUNTIF function? 41:18 2014-02-04
2 Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods) 6:09 2014-11-20
3 Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula? 12:38 2016-09-03
4 Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables. 5:07 2016-09-06
5 Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data) 7:00 2013-08-17
6 Excel Magic Trick 1027: Array Formula To Count Unique Yes Votes For A Given First & Last Name 9:41 2013-07-26
7 Excel Magic Trick 627: FREQUENCY Array Function (10 Examples) 51:50 2010-06-16
8 Excel Magic Trick 620: Count Unique Items in List - Robust Formulas & A Few Array Formula Tricks 17:40 2010-06-04
9 Excel Magic Trick 368: Count Unique Items With More Than One Criteria 14:02 2009-08-13
10 Excel Magic Trick 1153: Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… 10:25 2014-11-20
11 Excel 2013 PowerPivot Basics #04: DAX Formulas Can Be Easier & Faster Than Array Formulas 9:19 2014-10-10
12 Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transform) 6:13 2016-09-07
13 Excel Magic Trick 1392: Case Sensitive Unique Count: Power Query or Data Model PivotTable? 3:56 2017-03-12

Embed a badge

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

Watch time: 3h 15m · 13 videos

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