playlistduration

Excel Extracting and Sorting Formulas

by excelisfun · 31 videos

Total watch time

4h 55m

at 1× speed · exactly 4 hours, 54 minutes, 49 seconds at 1×

1×4h 54m 49s
1.25×3h 55m 51s
1.5×3h 16m 33s
1.75×2h 48m 28s
2×2h 27m 25s
Average video9m 31s
Longest54m 46s
Shortest53s
Compare Open on YouTube JSON

Plan to finish

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

Videos (31)

4h 55m 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 20: Extract Unique Lists & Sorting Formulas 54:46 2014-02-13
2 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
3 Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529) 17:03 2018-11-07
4 Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523 4:46 2018-11-01
5 Excel Dynamic Array UNIQUE with INDIRECT To Extract Unique Lists for Each Column (EMT 1522) 4:05 2018-10-26
6 Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data 15:51 2016-08-17
7 Excel Magic Trick 765: Formula To Sort Top 3, Including Ties 9:26 2011-03-08
8 Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data 5:47 2011-03-05
9 Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range 17:02 2010-12-31
10 Mr Excel & excelisfun Trick 58.5: Sorting Formula For Biggest Sales and Sales Rep Names with Ties 5:24 2010-12-17
11 Mr Excel & excelisfun Trick 58: Sorting Formula For Biggest Sales and Sales Rep Names with Ties 9:35 2010-12-03
12 Excel Magic Trick 471: Sort Horizontal With Formula 3 Examples 4:48 2010-01-01
13 Mr Excel & excelisfun Trick 12: Sort Numbers With Formula 7:24 2009-05-28
14 Excel Magic Trick 163 Formula Return Descending Sorted List 7:12 2008-12-02
15 Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally 21:24 2015-04-22
16 Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers 11:27 2015-06-06
17 Excel Magic Trick 1315: Create A Unique Sorted List with Power Query 4:16 2016-08-22
18 Excel Magic Trick 1315: Create A Unique Sorted List with Power Query 4:16 2016-08-22
19 Excel Magic Trick 1252: Power Query To Create Unique List of Invoice Numbers with Balances 4:03 2016-01-12
20 Excel Magic Trick 1159: Extract Unique List For Data Validation List with Power Query 4:26 2014-11-27
21 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530) 12:31 2018-11-09
22 Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531) 6:46 2018-11-11
23 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
24 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
25 Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575 4:11 2019-07-25
26 Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575 4:11 2019-07-25
27 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
28 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
29 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13
30 Sort "City, State" Text by State Then City | SORTBY Array Function - EMT 1923 3:58 2026-08-06
31 Excel Sort Left To Right. Horizontal Sort. Excel Short 83 0:53 2026-08-05

Embed a badge

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

Watch time: 4h 55m · 31 videos

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