-
1
23:31
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter
by ExcelIsFun 38,125 views
-
2
15:12
Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods
by ExcelIsFun 11,402 views
-
3
15:06
Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions
by ExcelIsFun 13,403 views
-
6
12:43
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
by ExcelIsFun 48,164 views
-
7
8:19
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula
by ExcelIsFun 17,539 views
-
8
8:24
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
by ExcelIsFun 19,391 views
-
9
16:02
Excel Magic Trick 900: Simulate Filter With Formula to Create Immediate Filter Results
by ExcelIsFun 7,609 views
-
10
17:02
Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range
by ExcelIsFun 32,598 views
-
11
9:29
Excel Magic Trick 893: Extract & Sort Records When Value Greater Than 75: Filter or Formula
by ExcelIsFun 3,140 views
-
12
10:04
Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula
by ExcelIsFun 5,054 views
-
14
6:28
Excel Magic Trick 753: Extract Records For Invoices 30 Days Past Due -- Filter Method
by ExcelIsFun 3,240 views
-
15
14:19
Excel Magic Trick 754: Extract Records For Invoices 30 Days Past Due -- Formula Method
by ExcelIsFun 4,466 views
-
16
12:57
Excel Magic Trick 755: Extract Records For Invoices 30 Days Past Due -- Advanced Filter & MACRO
by ExcelIsFun 7,694 views
-
17
8:19
Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data
by ExcelIsFun 8,971 views
-
19
11:33
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through
by ExcelIsFun 29,403 views
-
21
25:52
Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methods
by ExcelIsFun 5,422 views
-
23
2:30
Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria)
by ExcelIsFun 13,814 views
-
24
2:25
Excel Magic Trick #249: Data Extract To New Workbook using Advanced Filter
by ExcelIsFun 9,909 views
-
36
10:07
Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice
by ExcelIsFun 32,890 views
-
39
6:11
Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheet
by ExcelIsFun 2,201 views
-
41
17:44
Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)
by ExcelIsFun 21,463 views
-
42
5:50
Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method
by ExcelIsFun 7,478 views
-
43
8:32
Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method
by ExcelIsFun 6,854 views
-
44
4:02
Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter
by ExcelIsFun 7,053 views
-
45
5:23
Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula
by ExcelIsFun 3,423 views
-
46
4:25
Excel Magic Trick 595: DGET #NUM! Error same as Advanced Filter Duplicate Problem Extract Record
by ExcelIsFun 4,479 views
-
47
11:06
Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods
by ExcelIsFun 13,890 views
-
48
13:54
Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free
by ExcelIsFun 6,483 views
-
50
8:01
Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function
by ExcelIsFun 5,809 views
-
51
10:34
Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods
by ExcelIsFun 2,891 views
-
52
12:12
Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail
by ExcelIsFun 6,159 views
-
53
14:17
Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract
by ExcelIsFun 6,082 views
-
54
17:57
Excel Magic Trick 690: Extract Unique Records Based on 2 Columns, List Values Horizontally
by ExcelIsFun 3,896 views
-
55
15:03
Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending
by ExcelIsFun 4,614 views
-
56
5:47
Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data
by ExcelIsFun 5,818 views
-
58
17:52
Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List
by ExcelIsFun 13,548 views
-
60
17:44
Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)
by ExcelIsFun 21,463 views
-
62
5:47
Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data
by ExcelIsFun 5,818 views
-
63
17:02
Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range
by ExcelIsFun 32,598 views
-
64
10:15
Excel Magic Trick 785: Extract Top 3 Customer Names With Formula (Robust Formula Handles Dups)
by ExcelIsFun 4,039 views
-
65
17:43
Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheets
by ExcelIsFun 25,406 views
-
66
14:53
Excel 2010 Magic Trick 790: Formulas Convert Single Records Into Columns & Repeat Unique Identifier
by ExcelIsFun 4,404 views
-
67
10:21
Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula
by ExcelIsFun 8,541 views
-
68
7:40
Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Records
by ExcelIsFun 5,062 views
-
69
7:30
Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records
by ExcelIsFun 6,578 views
-
70
10:29
Excel 2010 Magic Trick 798: Partial Text Lookup Formula To Return Multiple E-mail Records
by ExcelIsFun 8,608 views
-
71
13:23
Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE
by ExcelIsFun 4,361 views
-
72
10:21
Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula
by ExcelIsFun 8,541 views
-
73
12:46
Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010
by ExcelIsFun 4,369 views
-
74
10:52
Excel 2010 Magic Trick 877: Manager Sales Rep Report: OR Criteria Formula To Extract Records
by ExcelIsFun 2,818 views
-
75
12:52
Excel 2010 Magic Trick 878: Manager Sales Rep Report: OR & AND Criteria Formula To Extract Records
by ExcelIsFun 2,518 views
-
76
8:07
Excel 2010 Magic Trick 880: Multiple OR Criteria Using MATCH function For Extracting Data Formula
by ExcelIsFun 6,939 views
-
77
7:30
Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula
by ExcelIsFun 3,435 views
-
78
8:31
Excel Magic Trick 899: Lookup Column of Data, Match Criterion, Display Items Vertically
by ExcelIsFun 4,419 views
-
79
6:58
Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)
by ExcelIsFun 5,100 views
-
80
8:19
Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups)
by ExcelIsFun 3,063 views
-
81
22:34
Excel Magic Trick 970: Extract Records Where Number is Divisible by 5 (5 Examples)
by ExcelIsFun 4,289 views
Extract With Advanced Filter
Extract With Formulas
Extract With VLOOKUP function
DGET With function
Extract With Filter
And more...
About excelisfun -- Excel How To Videos
29,760,522 views