Excel Extract Data (Records) From Table / List / Database

17 likes, 0 dislikes

23:31

1

Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter

by ExcelIsFun 38,125 views
15:12

2

Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods

by ExcelIsFun 11,402 views
15:06

3

Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions

by ExcelIsFun 13,403 views
2:21

4

Excel Magic Trick #212: Filter Copy Paste Data Extract

by ExcelIsFun 13,027 views
7:46

5

Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter

by ExcelIsFun 33,391 views
12:43

6

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

by ExcelIsFun 48,164 views
8:19

7

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

by ExcelIsFun 17,539 views
8:24

8

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

by ExcelIsFun 19,391 views
16:02

9

Excel Magic Trick 900: Simulate Filter With Formula to Create Immediate Filter Results

by ExcelIsFun 7,609 views
17:02

10

Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range

by ExcelIsFun 32,598 views
9:29

11

Excel Magic Trick 893: Extract & Sort Records When Value Greater Than 75: Filter or Formula

by ExcelIsFun 3,140 views
10:04

12

Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula

by ExcelIsFun 5,054 views
1:51

13

Excel Magic Trick 660: Advanced Filter Unique Records Only

by ExcelIsFun 7,732 views
6:28

14

Excel Magic Trick 753: Extract Records For Invoices 30 Days Past Due -- Filter Method

by ExcelIsFun 3,240 views
14:19

15

Excel Magic Trick 754: Extract Records For Invoices 30 Days Past Due -- Formula Method

by ExcelIsFun 4,466 views
12:57

16

Excel Magic Trick 755: Extract Records For Invoices 30 Days Past Due -- Advanced Filter & MACRO

by ExcelIsFun 7,694 views
8:19

17

Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data

by ExcelIsFun 8,971 views
7:55

18

YTLE#67: VLOOKUP & DGET functions

by ExcelIsFun 12,678 views
11:33

19

Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through

by ExcelIsFun 29,403 views
2:34

20

Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria

by ExcelIsFun 10,470 views
25:52

21

Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methods

by ExcelIsFun 5,422 views
11:05

22

Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria

by ExcelIsFun 24,039 views
2:30

23

Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria)

by ExcelIsFun 13,814 views
2:25

24

Excel Magic Trick #249: Data Extract To New Workbook using Advanced Filter

by ExcelIsFun 9,909 views
12:55

25

Excel Magic Trick 308: Extract Data To New Workbook W Formula

by ExcelIsFun 14,466 views
8:16

26

Excel Magic Trick 434: Extract Completed Records with Formula

by ExcelIsFun 2,700 views
9:41

27

Excel Magic Trick #187: Unique List w Dynamic Formula

by ExcelIsFun 23,355 views
3:58

28

Excel Magic Trick #211: Advanced Filter Extract ID Variable

by ExcelIsFun 4,135 views
10:52

29

Excel Magic Trick # 273: Extract Top 5 Records w Formula

by ExcelIsFun 5,550 views
5:10

30

Excel Magic Trick #105: Extract Records Trick

by ExcelIsFun 7,902 views
10:06

31

YTLE#95: Complex Advanced Filter Extract

by ExcelIsFun 5,699 views
2:26

32

YouTubersLoveExcel#33: Extract Red Cells

by ExcelIsFun 2,345 views
3:02

33

Excel Magic Trick 310: D Functions & Date Criteria

by ExcelIsFun 7,744 views
6:56

34

Excel Magic Trick 338: Extract Records By E-mail Extension

by ExcelIsFun 4,113 views
5:48

35

Excel Magic Trick 341 Extract Data w OFFSET & INDEX function

by ExcelIsFun 19,060 views
10:07

36

Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice

by ExcelIsFun 32,890 views
5:53

37

Excel Magic Trick 435: Extract Duplicate Records with Formula

by ExcelIsFun 7,125 views
3:28

38

Excel Magic Trick 432: Find & Extract Duplicate Records

by ExcelIsFun 11,309 views
6:11

39

Excel Magic Trick 447: AND & OR functions For Advanced Filter Extract to New Sheet

by ExcelIsFun 2,201 views
10:12

40

Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria

by ExcelIsFun 57,260 views
17:44

41

Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)

by ExcelIsFun 21,463 views
5:50

42

Excel Magic Trick 539: Extract New Records Not In Old List -- Filter Method

by ExcelIsFun 7,478 views
8:32

43

Excel Magic Trick 540: Extract New Records Not In Old List - Array Formula Method

by ExcelIsFun 6,854 views
4:02

44

Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter

by ExcelIsFun 7,053 views
5:23

45

Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula

by ExcelIsFun 3,423 views
4:25

46

Excel Magic Trick 595: DGET #NUM! Error same as Advanced Filter Duplicate Problem Extract Record

by ExcelIsFun 4,479 views
11:06

47

Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods

by ExcelIsFun 13,890 views
13:54

48

Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free

by ExcelIsFun 6,483 views
8:37

49

Excel Magic Trick 622: Array Formula to Return Even Row Data Only

by ExcelIsFun 2,575 views
8:01

50

Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function

by ExcelIsFun 5,809 views
10:34

51

Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods

by ExcelIsFun 2,891 views
12:12

52

Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail

by ExcelIsFun 6,159 views
14:17

53

Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract

by ExcelIsFun 6,082 views
17:57

54

Excel Magic Trick 690: Extract Unique Records Based on 2 Columns, List Values Horizontally

by ExcelIsFun 3,896 views
15:03

55

Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending

by ExcelIsFun 4,614 views
5:47

56

Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data

by ExcelIsFun 5,818 views
9:26

57

Excel Magic Trick 765: Formula To Sort Top 3, Including Ties

by ExcelIsFun 4,019 views
17:52

58

Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List

by ExcelIsFun 13,548 views
51:50

59

Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)

by ExcelIsFun 11,482 views
17:44

60

Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)

by ExcelIsFun 21,463 views
9:26

61

Excel Magic Trick 765: Formula To Sort Top 3, Including Ties

by ExcelIsFun 4,019 views
5:47

62

Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data

by ExcelIsFun 5,818 views
17:02

63

Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range

by ExcelIsFun 32,598 views
10:15

64

Excel Magic Trick 785: Extract Top 3 Customer Names With Formula (Robust Formula Handles Dups)

by ExcelIsFun 4,039 views
17:43

65

Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheets

by ExcelIsFun 25,406 views
14:53

66

Excel 2010 Magic Trick 790: Formulas Convert Single Records Into Columns & Repeat Unique Identifier

by ExcelIsFun 4,404 views
10:21

67

Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula

by ExcelIsFun 8,541 views
7:40

68

Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Records

by ExcelIsFun 5,062 views
7:30

69

Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records

by ExcelIsFun 6,578 views
10:29

70

Excel 2010 Magic Trick 798: Partial Text Lookup Formula To Return Multiple E-mail Records

by ExcelIsFun 8,608 views
13:23

71

Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE

by ExcelIsFun 4,361 views
10:21

72

Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula

by ExcelIsFun 8,541 views
12:46

73

Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010

by ExcelIsFun 4,369 views
10:52

74

Excel 2010 Magic Trick 877: Manager Sales Rep Report: OR Criteria Formula To Extract Records

by ExcelIsFun 2,818 views
12:52

75

Excel 2010 Magic Trick 878: Manager Sales Rep Report: OR & AND Criteria Formula To Extract Records

by ExcelIsFun 2,518 views
8:07

76

Excel 2010 Magic Trick 880: Multiple OR Criteria Using MATCH function For Extracting Data Formula

by ExcelIsFun 6,939 views
7:30

77

Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula

by ExcelIsFun 3,435 views
8:31

78

Excel Magic Trick 899: Lookup Column of Data, Match Criterion, Display Items Vertically

by ExcelIsFun 4,419 views
6:58

79

Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)

by ExcelIsFun 5,100 views
8:19

80

Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups)

by ExcelIsFun 3,063 views
22:34

81

Excel Magic Trick 970: Extract Records Where Number is Divisible by 5 (5 Examples)

by ExcelIsFun 4,289 views

See how to extract records from Database Table / List using:

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

Highline Community College Teacher, Mike Girvin has created over 1900 Videos, 90 Playlists. Excel Efficiency Tricks so you can work faster, have more fun & help others with Excel. To get free Excel training, watch playlists of videos: 1) Excel Basics, 2) Highline Excel Class. Free Excel Lessons. Learn Excel for Free. Free Excel Tutorials.

102 playlists by excelisfun -- Excel How To Videos View all videos

29,760,522 views

83,298

Featured Playlists

2,030 videos Play all