playlistduration

Excel Extract Data (Records) From Table / List / Database: Playlist of Videos

by excelisfun · 177 videos

Total watch time

1d 7h 55m

at 1× speed · exactly 1 day, 7 hours, 54 minutes, 41 seconds at 1×

1×1d 7h 54m 41s
1.25×1d 1h 31m 45s
1.5×21h 16m 27s
1.75×18h 14m 6s
2×15h 57m 21s
Average video10m 49s
Longest1h 14m 12s
Shortest1m 18s
Compare Open on YouTube JSON

Plan to finish

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

Videos (177)

1d 7h 55m 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 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter 23:32 2010-09-03
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 MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop 19:11 2018-09-10
5 Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods 15:12 2010-12-26
6 Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions 15:06 2010-12-28
7 Excel Magic Trick 900: Simulate Filter With Formula to Create Immediate Filter Results 16:02 2012-04-03
8 Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range 17:02 2010-12-31
9 Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula 12:43 2009-08-13
10 Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula 8:20 2009-08-13
11 Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula 8:24 2009-08-13
12 Excel Magic Trick 1244: Transform GDP Data Set: Advanced Filter with Formula Criteria wins! 7:33 2015-11-14
13 Excel Magic Trick #212: Filter Copy Paste Data Extract 2:21 2009-01-19
14 Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter 7:46 2009-01-09
15 Excel Magic Trick 893: Extract & Sort Records When Value Greater Than 75: Filter or Formula 9:28 2012-03-30
16 Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula 10:04 2012-03-30
17 Excel Magic Trick 660: Advanced Filter Unique Records Only 1:51 2010-07-17
18 Excel Magic Trick 753: Extract Records For Invoices 30 Days Past Due -- Filter Method 6:28 2010-12-13
19 Excel Magic Trick 754: Extract Records For Invoices 30 Days Past Due -- Formula Method 14:20 2010-12-13
20 Excel Magic Trick 755: Extract Records For Invoices 30 Days Past Due -- Advanced Filter & MACRO 12:57 2010-12-13
21 Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data 8:19 2010-07-17
22 YTLE#67: VLOOKUP & DGET functions 7:55 2008-07-28
23 Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through 11:33 2010-03-05
24 Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria 2:35 2009-01-09
25 Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methods 25:52 2010-02-24
26 Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria 11:05 2009-01-09
27 Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria) 2:31 2009-02-03
28 Excel Magic Trick #249: Data Extract To New Workbook using Advanced Filter 2:25 2009-02-04
29 Excel Magic Trick 308: Extract Data To New Workbook W Formula 12:55 2009-05-01
30 Excel Magic Trick 434: Extract Completed Records with Formula 8:16 2009-11-02
31 Excel Magic Trick #187: Unique List w Dynamic Formula 9:41 2009-01-09
32 Excel Magic Trick #211: Advanced Filter Extract ID Variable 3:58 2009-01-19
33 Excel Magic Trick # 273: Extract Top 5 Records w Formula 10:52 2009-03-02
34 Excel Magic Trick #105: Extract Records Trick 5:10 2008-09-26
35 YTLE#95: Complex Advanced Filter Extract 10:07 2008-08-12
36 YouTubersLoveExcel#33: Extract Red Cells 2:26 2008-06-11
37 Excel Magic Trick 310: D Functions & Date Criteria 3:02 2009-05-01
38 Excel Magic Trick 338: Extract Records By E-mail Extension 6:56 2009-06-15
39 Excel Magic Trick 341 Extract Data w OFFSET & INDEX function 5:49 2009-06-22
40 Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice 10:07 2009-08-13
41 Excel Magic Trick 435: Extract Duplicate Records with Formula 5:53 2009-11-02
42 Excel Magic Trick 432: Find & Extract Duplicate Records 3:28 2009-11-02
43 Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheet 6:11 2009-11-16
44 Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria 10:12 2009-01-09
45 Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula) 17:44 2010-01-05
46 Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method 5:50 2010-03-12
47 Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method 8:33 2010-03-12
48 Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter 4:02 2010-04-27
49 Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula 5:23 2010-05-07
50 Excel Magic Trick 595: DGET #NUM! Error same as Advanced Filter Duplicate Problem Extract Record 4:25 2010-05-07
51 Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods 11:06 2010-05-24
52 Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free 13:54 2010-05-24
53 Excel Magic Trick 622: Array Formula to Return Even Row Data Only 8:37 2010-06-04
54 Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function 8:01 2010-07-17
55 Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods 10:35 2010-08-06
56 Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail 12:12 2010-09-03
57 Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract 14:17 2010-09-03
58 Excel Magic Trick 690: Extract Unique Records Based on 2 Columns, List Values Horizontally 17:58 2010-11-15
59 Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending 15:03 2011-03-03
60 Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data 5:47 2011-03-05
61 Excel Magic Trick 765: Formula To Sort Top 3, Including Ties 9:26 2011-03-08
62 Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List 17:52 2010-09-03
63 Excel Magic Trick 627: FREQUENCY Array Function (10 Examples) 51:50 2010-06-16
64 Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula) 17:44 2010-01-05
65 Excel Magic Trick 765: Formula To Sort Top 3, Including Ties 9:26 2011-03-08
66 Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data 5:47 2011-03-05
67 Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range 17:02 2010-12-31
68 Excel Magic Trick 785: Extract Top 3 Customer Names With Formula (Robust Formula Handles Dups) 10:15 2011-05-21
69 Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheets 17:43 2011-06-06
70 Excel 2010 Magic Trick 790: Formulas Convert Single Records Into Columns & Repeat Unique Identifier 14:54 2011-06-07
71 Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula 10:21 2011-09-02
72 Excel 2010 Magic Trick 798: Partial Text Lookup Formula To Return Multiple E-mail Records 10:29 2011-09-06
73 Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records 7:30 2011-09-09
74 Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Records 7:40 2011-09-09
75 Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE 13:23 2011-09-06
76 Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula 10:21 2011-09-02
77 Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010 12:46 2011-12-21
78 Excel 2010 Magic Trick 877: Manager Sales Rep Report: OR Criteria Formula To Extract Records 10:52 2012-03-06
79 Excel 2010 Magic Trick 878: Manager Sales Rep Report: OR & AND Criteria Formula To Extract Records 12:52 2012-03-06
80 Excel 2010 Magic Trick 880: Multiple OR Criteria Using MATCH function For Extracting Data Formula 8:07 2012-03-08
81 Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula 7:30 2012-04-02
82 Excel Magic Trick 899: Lookup Column of Data, Match Criterion, Display Items Vertically 8:31 2012-04-03
83 Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order) 6:58 2012-05-12
84 Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups) 8:19 2012-06-28
85 Excel Magic Trick 970: Extract Records Where Number is Divisible by 5 (5 Examples) 22:34 2012-11-02
86 Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List 14:42 2013-07-24
87 Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables 10:08 2013-08-03
88 Ctrl + Shift + Enter: Excel Array Formulas 16: Formulas To Extract Records With Criteria 23 examples 1:14:12 2014-01-29
89 Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL 22:03 2014-02-23
90 Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula 5:11 2014-05-15
91 Excel Magic Trick 1109: Compare 2 Lists and Extract Records: Advanced Filter Method 5:17 2014-05-13
92 Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method 12:59 2014-05-13
93 Excel Magic Trick 1108: Compare 2 Lists and Extract Records: Filter Method 5:12 2014-05-13
94 Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula 26:34 2014-07-13
95 Excel Magic Trick 1130: Aging Accounts Receivable Reports Using Advanced Filter & Page Setup 6:51 2014-07-15
96 Excel Magic Trick 1129: Aging Accounts Receivable Reports Using Slicer, Excel Table, Page Setup 9:20 2014-07-15
97 Excel Magic Trick 1133: Aging Accounts Receivable Reports: PivotTable & Unique Identifier 9:37 2014-07-16
98 Excel Magic Trick 1143: Extract Content From Non-Empty Cells: Filter or Array Formula? 11:09 2014-10-11
99 Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples) 7:31 2014-12-06
100 Excel Power Query #11: Each Row Has 3 Records, Unwind Table into Proper Data Set 6:00 2014-12-08
101 Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally 21:24 2015-04-22
102 Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers 11:27 2015-06-06
103 Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) 22:32 2015-08-14
104 Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? 17:18 2016-02-05
105 Highline Excel 2016 Class 19: Transform Data Sets using Advanced Filter (8 Examples) 33:42 2016-06-04
106 Excel Magic Trick 1324: ROWS or COUNTIFS Incrementor in Array Formula to Extracting Records? 19:21 2016-09-16
107 Excel Magic Trick 1346: Array Formula: Split Master Table into Sub Tables, Each Product on New Sheet 22:05 2016-11-17
108 Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records 18:02 2016-11-21
109 Excel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each Product 21:05 2016-11-18
110 Excel Magic Trick 1353: Power Query: Extract Records w Merge Feature & Inner Join on Parameter Table 12:23 2016-12-02
111 Excel Magic Trick 1355 Extract Data at each Bold Font, Display Horizontally: GET.CELL Macro Function 25:26 2016-12-06
112 Excel Magic Trick 1370 INDEX Function & Number Incrementor Extract Items & Display In Every 3rd Cell 9:27 2017-01-19
113 Excel Magic Trick 1373: Formula to Extract Every Nth Value & Conditionally Format Every Nth Value 12:54 2017-01-27
114 Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function 7:05 2017-01-29
115 Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function 7:05 2017-01-29
116 Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More 18:52 2017-02-09
117 Excel Magic Trick 1381: Power Query: Records In Column into Table then Two Different Top 3 Reports 20:43 2017-02-18
118 Excel Magic Trick 1382: Extract Records With Multiple Contains (Partial Text) Criteria: 4 Examples 38:13 2017-02-22
119 Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet 8:00 2017-05-28
120 Excel Magic Trick 1442 DAX Query & EXCEPT Function to Extract Items In List 1 That Are NOT In List 2 8:54 2017-06-21
121 Excel Magic Trick 1441 Power Query to Extract Items In List 1 That Are NOT In List 2: Left Anti Join 5:52 2017-06-19
122 Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups 27:23 2017-07-06
123 Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) 39:40 2018-10-20
124 Excel Dynamic Array UNIQUE with INDIRECT To Extract Unique Lists for Each Column (EMT 1522) 4:05 2018-10-26
125 Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523 4:46 2018-11-01
126 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530) 12:31 2018-11-09
127 Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531) 6:46 2018-11-11
128 VLOOKUP To Get Complete Record: ROWS, COLUMNS or SEQUENCE Function? EMT 1532 8:30 2018-12-15
129 Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array). 5:46 2019-02-12
130 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
131 Unique Invoice / Vendor List with Items Listed Horizontally - Excel Dynamic Array Formula- EMT 1575 4:11 2019-07-25
132 Power Query M Code Group By Formula to Transform Invoice Table - Excel Magic Trick 1576 7:25 2019-07-26
133 Array Formula - List All Suppliers by Material in Single Cell with Line Feed, Excel Magic Trick 1579 5:52 2019-07-29
134 Power Query - Group Suppliers, Join with Line Feed From Multiple Text Files - Excel Magic Trick 1580 9:30 2019-07-30
135 One Lookup Value, Return Multiple Items – The Easy Way with FILTER - Excel Magic Trick 1591 1:44 2019-08-19
136 Extract Customer Names, Not in Master Lists with Advanced Filter - Excel Magic Trick 1598 5:06 2019-09-02
137 Advanced Filter: Filter Rows with List of Does NOT Contain Criteria - Excel Magic Trick 1594 4:01 2019-08-25
138 Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600 25:02 2019-09-06
139 Extract Top 5 Values with Names with Dynamic Array Formulas & Conditional Formatting – EMT 1610 4:47 2019-10-08
140 Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653 3:33 2020-03-25
141 INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654 4:31 2020-03-26
142 Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661 8:18 2020-04-23
143 Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663 6:49 2020-04-28
144 Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664 10:42 2020-05-01
145 Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665. 8:49 2020-05-05
146 Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674 6:07 2020-06-29
147 Append Two Number Columns and Sort. Excel Magic Trick 1682. 5:10 2020-08-10
148 FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685. 5:08 2020-08-25
149 OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697. 6:11 2020-10-25
150 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716 4:52 2021-01-13
151 Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717 6:57 2021-01-15
152 Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2 1:18 2021-02-04
153 Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737. 9:45 2021-05-24
154 Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741 2:43 2021-06-22
155 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
156 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752 9:14 2021-09-07
157 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
158 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
159 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786 6:29 2022-03-25
160 TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789 3:26 2022-04-04
161 XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791 6:59 2022-04-21
162 FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799 4:41 2022-10-10
163 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805 8:06 2022-11-29
164 Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807 7:37 2022-12-09
165 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 9:47 2023-01-07
166 Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shorts 2:45 2023-01-16
167 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820 3:53 2023-04-25
168 Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822 2:54 2023-06-29
169 FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841 8:29 2023-10-18
170 FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842 3:33 2023-10-25
171 FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843 2:23 2023-11-01
172 Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854 3:23 2024-02-26
173 Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856 5:52 2024-03-04
174 UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861 1:56 2024-07-15
175 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
176 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
177 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13

Embed a badge

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

Watch time: 1d 7h 55m · 177 videos

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