1
Highline Excel 2016 Class 05: Excel Array Formulas: Comprehensive Lessons: 12 Examples
52:01
2016-05-01
2
Highline Excel Class 36: Array Formulas Basics
31:35
2009-05-13
3
Highline Excel Class 37: SUMPRODUCT function
20:00
2009-05-13
4
Highline Excel Class 38: Array Functions TRANSPOSE FREQUENCY
5:55
2009-05-13
5
Highline Excel Class 39: Forcing Functions To Become Arrays
21:00
2009-05-13
6
Excel Magic Trick 425: Functions That Can Handle Array Syntax And Do Not Require CSE
8:02
2009-10-26
7
Excel Magic Trick 440: Array Formulas Advanced Tips
23:15
2009-11-16
8
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
12:43
2009-08-13
9
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula
8:20
2009-08-13
10
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
8:24
2009-08-13
11
Excel Magic Trick 620: Count Unique Items in List - Robust Formulas & A Few Array Formula Tricks
17:40
2010-06-04
12
Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods
11:06
2010-05-24
13
Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free
13:54
2010-05-24
14
Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)
17:44
2010-01-05
15
Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)
51:50
2010-06-16
16
Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0
6:07
2009-05-01
17
Excel Array Formula Series 12: MMULT function Matrix Algebra
2:22
2008-06-26
18
Excel Array Formula Series #13: LINEST function
10:25
2008-06-26
19
Excel Magic Trick 785: Extract Top 3 Customer Names With Formula (Robust Formula Handles Dups)
10:15
2011-05-21
20
Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Function
11:16
2011-09-27
21
Excel 2010 Magic Trick 877: Manager Sales Rep Report: OR Criteria Formula To Extract Records
10:52
2012-03-06
22
Excel 2010 Magic Trick 878: Manager Sales Rep Report: OR & AND Criteria Formula To Extract Records
12:52
2012-03-06
23
Excel Magic Trick 944: How To Create Your Own Original Array Formula From Scratch
15:06
2012-07-13
24
Excel Magic Trick 1006: Insurance Calculation: MMULT Function to add from rows in a 2-Way Array
11:01
2013-06-25
25
Excel Magic Trick 1009: Lookup 3 Different Arrays From 3 Different Tables: VLOOKUP, CHOOSE, INDEX
15:08
2013-06-27
26
Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows
12:42
2013-07-08
27
Excel Magic Trick 1013: MIN IF, MAX IF, MINIF, MAXIF (6 Examples) MAX MIN calculation w 1 criteria
11:08
2013-07-13
28
Excel Magic Trick 1021: Implicit Intersection or #VALUE Error: No Ctrl + Shift + Enter
7:26
2013-07-17
29
Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List
14:42
2013-07-24
30
Excel Magic Trick 1027: Array Formula To Count Unique Yes Votes For A Given First & Last Name
9:41
2013-07-26
31
Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...
5:13
2013-07-31
32
Excel Magic Trick 1036: SUM Rectangular Table, 1 condition Row Headers & Or Criteria Column Headers
6:02
2013-08-05
33
Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text
8:58
2013-08-12
34
Excel Magic Trick 1042 Array Functions Housed In Other Functions Usually Don't Need Ctrl Shift Enter
7:37
2013-08-14
35
Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data)
7:00
2013-08-17
36
Excel Magic Trick 1044: Formula To Extract & Sort Unique List Of Numbers Contains Empty Cells & Text
8:30
2013-08-17
37
Ctrl + Shift + Enter: Excel Array Formulas Video # 24: 26 Amazing Array Formulas
1:20:51
2014-03-04
38
Excel Magic Trick 1101: Calculate MEDIAN Based On Lower/Upper Date, Exclude Holidays & Weekends
16:10
2014-04-21
39
Excel Magic Trick 1105: Minimum With Two Criteria: When NOT to use Array Formula: DMIN
3:04
2014-05-03
40
Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable
5:23
2015-03-27
41
Excel Magic Trick 1222: Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format?
6:49
2015-08-08
42
Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score
6:24
2016-03-18
43
Excel Magic Trick 1294: Single Cell "Lookup Adding" w Improper Data Set to Score Myers-Briggs Test
7:10
2016-03-19
44
Excel Magic Trick 1296: COUNTIFS with OR Criteria & SUMPRODUCT to Score Myers-Briggs Test
4:04
2016-03-20
45
Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE
9:03
2016-05-17
46
Excel Magic Trick 1304: List Text Modes in Single Cell TEXTJOIN, INDEX, N, IF, MATCH & MODE.MULT
6:14
2016-07-15
47
Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trick
7:12
2016-07-17
48
Excel Magic Trick 1306: Simulate VLOOKUP Helper Column In Array Formula using T(IF({1},Array) Trick
10:40
2016-07-17
49
Excel Magic Trick 1311: Return Multiple Items from One Lookup Value & Show Total for Invoice Items
7:11
2016-07-25
50
Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.
20:54
2016-08-10
51
Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data
15:51
2016-08-17
52
Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data
15:51
2016-08-17
53
Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula?
12:38
2016-09-03
54
Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods)
26:42
2016-09-11
55
Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods)
26:42
2016-09-11
56
Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL?
30:37
2016-09-13
57
Blue Cover (3rd Printing) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book at mrexcel.com
1:11
2016-09-15
58
Excel Magic Trick 1324: ROWS or COUNTIFS Incrementor in Array Formula to Extracting Records?
19:21
2016-09-16
59
Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples)
31:55
2016-09-24
60
Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query?
24:51
2016-10-04
61
Excel Magic Trick 1346: Array Formula: Split Master Table into Sub Tables, Each Product on New Sheet
22:05
2016-11-17
62
Excel Magic Trick 1348: Lookup Adding: Exact Match or Approximate Match (SUM Many VLOOKUPs)
13:32
2016-11-23
63
Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?
18:07
2016-11-30
64
Excel Magic Trick 1382: Extract Records With Multiple Contains (Partial Text) Criteria: 4 Examples
38:13
2017-02-22
65
Excel Magic Trick 1388 Average Number of Days Between Order & Ship Date (Basic Array Formula Lesson)
12:03
2017-03-06
66
Excel Magic Trick 1391: Case Sensitive VLOOKUP? 5 Examples of Excel Case Sensitive Lookup
14:35
2017-03-10
67
Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups
18:09
2017-07-02
68
Excel Magic Trick 1452: Max Monthly Customer Total for Year: Array Formula or PivotTable?
16:56
2017-08-06
69
Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month
13:46
2017-08-09
70
Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month
10:30
2017-08-11
71
Excel Magic Trick 1462: 5,000 Formulas in a Single Cell with SUMPRODUCT or Array Formula?
12:21
2017-09-09
72
Excel Magic Trick 1467: COUNTIFS or SUMPRODUCT for Complex Counting Formula? (3 Examples)
27:03
2017-09-28
73
Excel Magic Trick 1471: Array Formula: Add Daily Rainfall 5 AM to 5 AM Next Day: (Most Automatic)
37:16
2017-12-13
74
Excel Magic Trick 1482: SUMPRODUCT, DCOUNTA or SUM & IF for Counting with OR Logical Test
20:12
2018-04-04
75
Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date
13:35
2018-04-18
76
EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Table
15:37
2018-05-12
77
Excel Magic Trick 1511: Array Formula: Get Low Bid From Supplier When Delivery Less Than 20 Weeks
13:28
2018-07-25
78
Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)
39:40
2018-10-20
79
Excel Dynamic Arrays: Backward Compatibility? Forward Compatibility? What Happens? EMT 1519
6:18
2018-10-23
80
Excel Dynamic Arrays or Mixed Cell References for Cross Tabulated Reports? EMT 1518
7:44
2018-10-23
81
Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520
9:16
2018-10-24
82
Excel Dynamic Array UNIQUE with INDIRECT To Extract Unique Lists for Each Column (EMT 1522)
4:05
2018-10-26
83
Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports With Totals!!!!! EMT 1528
13:02
2018-10-28
84
VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521)
9:57
2018-10-30
85
Excel Dynamic Arrays: Data Validation List Dropdown: Unique, Sorted & No Blanks EMT 1523
4:46
2018-11-01
86
Dynamic Spilled Arrays: Show All Formulas For All Columns in Cells as Auditing Trail EMT 1524
4:51
2018-11-02
87
Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526)
7:29
2018-11-05
88
Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526)
7:29
2018-11-05
89
Excel Dynamic Arrays & Charts: Spilled Arrays in Charts with Defined Names (Excel Magic Trick 1527)
5:12
2018-11-06
90
Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529)
17:03
2018-11-07
91
Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530)
12:31
2018-11-09
92
Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)
6:46
2018-11-11
93
Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)
6:46
2018-11-11
94
Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column
6:00
2019-02-13
95
Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?!
7:09
2019-02-15
96
MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
13:38
2019-05-31
97
Count Number of Saturdays in Month - 5 Different Formulas!- Excel Magic Trick 1587
8:51
2019-08-11
98
Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600
25:02
2019-09-06
99
Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603
3:13
2019-09-18
100
Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604
3:29
2019-09-19
101
Sum Last Digits for All Numbers - Excel Magic Trick 1605
3:27
2019-09-20
102
Dynamic Array & Old Array Formulas to Create Student Classes Report - Excel Magic Trick 1608
7:48
2019-09-26
103
Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609
6:08
2019-09-29
104
Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609
6:08
2019-09-29
105
Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620
9:32
2019-11-25
106
OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645
6:35
2020-03-11
107
Append Multiple Columns with Excel Dynamic Spilled Array Formula. Excel Magic Trick 1646.
8:28
2020-03-13
108
Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647
8:05
2020-03-17
109
Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653
3:33
2020-03-25
110
INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654
4:31
2020-03-26
111
Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661
8:18
2020-04-23
112
Extract Data From Cell, Display Horizontally with Excel Formula. 5 Examples. Excel Magic Trick 1663
6:49
2020-04-28
113
Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665.
8:49
2020-05-05
114
Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.
6:08
2020-05-16
115
Remove Numbers from Text. Flash Fill, Power Query, Formula or LET Function? Excel Magic Trick 1670
12:18
2020-06-01
116
Lookup 2nd Smallest Number. 2nd Biggest too. UNIQUE or FREQUENCY function? Excel Magic Trick 1672
6:38
2020-06-15
117
Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674
6:07
2020-06-29
118
Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675.
6:01
2020-07-01
119
LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681.
14:32
2020-08-03
120
Append Two Number Columns and Sort. Excel Magic Trick 1682.
5:10
2020-08-10
121
List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687.
7:07
2020-09-07
122
OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697.
6:11
2020-10-25
123
Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703.
24:50
2020-11-23
124
12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707
14:38
2020-12-09
125
INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.
14:09
2021-01-05
126
Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713
9:24
2021-01-06
127
Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721
5:04
2021-02-01
128
Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722
5:06
2021-02-08
129
Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723
4:12
2021-02-12
130
Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.
5:34
2021-03-01
131
Private video
—
132
Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731
6:10
2021-03-30
133
Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737.
9:45
2021-05-24
134
Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740
11:18
2021-06-14
135
OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
10:33
2021-07-06
136
11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745
10:15
2021-07-20
137
Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808
4:39
2022-12-12
