Playlist Duration

Playlist · excelisfun

Excel Compare / Merge Two Lists

by excelisfun · 52 videos

Total watch time

6h 11m

at 1× speed · exactly 6 hours, 11 minutes, 24 seconds at 1×

At an hour a day you'd finish in 7 days

The shape of the course

52 videos in blocks of 10 · each column is a block's total, to scale

1h 16m
1h 11m
1h 2m
1h 1m
1h 26m
15m 2s

WatchedTo watch

Compare Open on YouTube JSON

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

Videos (52)

6h 11m 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.

Videos to
Watched Leave out of the total
1 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
2 Excel Formula to Compare Two Lists - Excel Magic Trick 1596. Is Item in List? 4:33 2019-08-28
3 Extract Customer Names, Not in Master Lists with Advanced Filter - Excel Magic Trick 1598 5:06 2019-09-02
4 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 9:47 2023-01-07
5 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
6 Excel Magic Trick 1229 Extract Items NOT in List 1: Conditional Format Unique Values & Sort by Color 2:37 2015-08-19
7 Excel Magic Trick 1108: Compare 2 Lists and Extract Records: Filter Method 5:12 2014-05-13
8 Excel Magic Trick 1109: Compare 2 Lists and Extract Records: Advanced Filter Method 5:17 2014-05-13
9 Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method 12:59 2014-05-13
10 Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula 5:11 2014-05-15
11 Excel Power Query #09: Merge Multiple Worksheets in Workbook To New Table using Append Feature 5:06 2014-12-06
12 Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks 9:35 2014-11-30
13 Excel 2013 Power Query #01: Append 3 Tables Into One in PowerPivot or Excel Table 5:31 2014-11-11
14 Excel Power Query #04: Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically 7:15 2014-11-28
15 Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model 6:32 2014-11-29
16 Excel Magic Trick #119: Is Item In List? 2 Examples 4:29 2009-05-07
17 Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists 8:08 2008-12-02
18 Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table 6:56 2010-03-27
19 Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functions 7:17 2010-02-24
20 Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice 10:07 2009-08-13
21 Excel Magic Trick 381: Merge Two Lists Tables w Advanced Filter and Remove Duplicates Feature 4:27 2009-09-10
22 Excel Magic Trick #245: Matching 2 Lists w IF & OR functions 2:29 2009-02-03
23 Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each List 6:26 2009-09-10
24 Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method 5:50 2010-03-12
25 Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method 8:33 2010-03-12
26 Excel Magic Trick 546: Is Item List? Case Sensitive OR & EXACT functions 2:41 2010-03-12
27 Excel Magic Trick 607: Match 3 Lists: Matching Accounting Documents PO, Receiving & Invoice 10:51 2010-05-20
28 Excel Magic Trick 717: List 2 Same Order as List 2? MATCH and ROWS functions 5:35 2010-09-09
29 Excel Magic Trick 719: Comparing Two Lists Trouble 2 Examples (Numbers Not Match Numbers As Text) 5:10 2010-09-09
30 Excel Magic Trick 520: FIND & SEARCH Functions 9:54 2010-02-23
31 Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match) 7:05 2009-05-09
32 Excel Magic Trick 309: Partial Text Match: Why 2^15? 6:10 2009-05-01
33 Excel Magic Trick 832: Merge Tables with Copy, Paste and Clipboard 1:53 2011-12-07
34 Excel Magic Trick 842: Is Item A Duplicate In Column? Excluding First Occurrence: COUNTIF 2:26 2011-12-15
35 Excel Magic Trick 843: Is Record Duplicate, Excluding First Occurrence? COUNTIFS Function 4:54 2011-12-15
36 Excel Magic Trick 946: Is Item In List NOT In Any Other List? (Check Against 3 Other Columns) 11:36 2012-07-16
37 Excel Magic Trick 946: Is Item In List NOT In Any Other List? (Check Against 3 Other Columns) 11:36 2012-07-16
38 Excel Magic Trick 1098: Compare Two E-mail Lists with Formula: E-mail In List? Not In List? 5:14 2014-04-17
39 Excel Magic Trick 1099: Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range 7:28 2014-04-17
40 Excel Magic Trick 1120: Is Item in All Three Lists? 2:23 2014-05-30
41 Excel 2013 Power Query #01: Append 3 Tables Into One in PowerPivot or Excel Table 5:31 2014-11-11
42 Excel Power Query #03: Import Multiple Text Files in 1 Step, and Amazing Pivot Chart For Grade Data 15:09 2014-11-23
43 Excel Magic Trick 1169: Are Items In Row In Master List? Filter & Conditionally Format To Highlight 7:11 2015-01-13
44 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
45 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
46 Excel Magic Trick 1464: Is Item In List? Formula to Check if Item is in a List on Separate Sheet. 9:42 2017-09-14
47 Excel Magic Trick 1465: Conditional Formatting Holiday Dates with Red Fill & Word "Holiday" 9:27 2017-09-20
48 Excel Magic Trick 1465: Conditional Formatting Holiday Dates with Red Fill & Word "Holiday" 9:27 2017-09-20
49 Excel Formula: Count Matches in Both Lists. Conditional Formatting to Format Matches. EMT 1613 3:47 2019-10-22
50 Compare Two Lists, Deliver Cell Address. Dueling Excel #194 with Mr Excel & Excelisfun 11:27 2020-09-04
51 Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766 11:09 2021-12-15
52 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820 3:53 2023-04-25
For your README

Embed a badge

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

Watch time: 6h 11m · 52 videos

Markdown
[![Watch time: 6h 11m · 52 videos](https://playlistduration.com/badge/playlist/PL83E0D7B674B73A06.svg)](https://playlistduration.com/playlist/PL83E0D7B674B73A06)
HTML
<a href="https://playlistduration.com/playlist/PL83E0D7B674B73A06"><img src="https://playlistduration.com/badge/playlist/PL83E0D7B674B73A06.svg" alt="Watch time: 6h 11m · 52 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/PL83E0D7B674B73A06 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-11-02 (cached). Private or deleted videos are excluded from totals.