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
