1
Excel 2010 Magic Trick 661: AGGREGATE function Contains 19 different functions
9:55
2010-07-22
2
Excel 2010 Magic Trick 662: AGGREGATE function Ignores Hidden Rows for Calculations
5:20
2010-07-22
3
Excel 2010 Magic Trick 663: AGGREGATE function Ignores Error Values for Calculations
4:26
2010-07-22
4
Excel 2010 Magic Trick 664: AGGREGATE function Ignores Nested SUBTOTALs for Calculations
5:13
2010-07-22
5
Excel 2010 Magic Trick 665: AGGREGATE function Ignores Filtered Values When Making Calculations
4:14
2010-07-22
6
Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formula
7:34
2010-07-22
7
Excel 2010 Magic Trick 667: AGGREGATE Function Array Formula #2 Return 5 Largest Values
7:49
2010-07-22
8
Excel 2010 Magic Trick 668: AGGREGATE Function Array Formula #3 Calculate 90 Percentile CPA Scores
6:50
2010-07-22
9
Excel 2010 Magic Trick 669: AGGREGATE function Can Not Handle 3-D Cell References
1:43
2010-07-22
10
Excel 2010 Magic Trick 670: AGGREGATE Function Array Formula #4 Extract Records 1 criterion
8:32
2010-07-22
11
Excel 2010 Magic Trick 671: AGGREGATE function Array Formula #5 Extract Records 2 criteria
8:09
2010-07-22
12
Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula
8:10
2010-07-22
13
Excel 2010 Magic Trick 790: Formulas Convert Single Records Into Columns & Repeat Unique Identifier
14:54
2011-06-07
14
Excel Magic Trick 819: Lookup Second 2nd Item In List: Excel 2010, 2007 and 2003 Methods
14:31
2011-10-21
15
Excel 2010 Magic Trick 821: 4-Way Lookup When There Are No Duplicates 2007 and 2003 Methods
9:35
2011-10-21
16
Excel 2010 Magic Trick 820: Conditional Formatting With Array Formulas!!??
10:03
2011-10-21
17
Excel 2010 Magic Trick 877: Manager Sales Rep Report: OR Criteria Formula To Extract Records
10:52
2012-03-06
18
Excel 2010 Magic Trick 878: Manager Sales Rep Report: OR & AND Criteria Formula To Extract Records
12:52
2012-03-06
19
Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE
10:15
2012-05-01
20
Excel Magic Trick 935: MAX Value Between Two Dates: DMAX, MAX-IF-IF, or AGGREGATE Function?
12:43
2012-06-27
21
Excel Magic Trick 1028: Create Hyperlinks to Duplicate Text Titles In Column A On Different Sheet
9:50
2013-07-30
22
Excel Magic Trick 1013: MIN IF, MAX IF, MINIF, MAXIF (6 Examples) MAX MIN calculation w 1 criteria
11:08
2013-07-13
23
Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)
7:23
2013-07-12
24
Excel Magic Trick 1005: Lookup nth Duplicate When Column With Lookup Value Is Not Sorted
7:50
2013-06-24
25
Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?
7:35
2013-05-23
26
Mr Excel & excelisfun Trick 121: MIN and MAX Between Two Dates For Each Region
9:12
2013-04-26
27
Mr Excel & excelisfun Trick 111: Slowest Time That Is Within 2 Seconds Of The Fastest
9:41
2013-02-01
28
Excel Magic Trick 986 One Lookup Value, Extract Multiple Items, Display Horizontally (A Closer Look)
14:46
2013-01-15
29
Excel Magic Trick 984: Lookup Penultimate: Get Second To Last Item From Column Of Mixed Data
6:44
2013-01-10
30
Excel Magic Trick 970: Extract Records Where Number is Divisible by 5 (5 Examples)
22:34
2012-11-02
31
Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates
17:34
2012-08-24
32
Excel Magic Trick 960: Add Noncontiguous ranges that have #N/A Errors
8:30
2012-08-06
33
Excel Magic Trick 914: Top 5, Bottom 5 Excluding Zeros: LARGE, SMALL & AGGREGATE Functions
9:14
2012-05-04
34
Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE
10:15
2012-05-01
35
Excel Magic Trick 1035: Calculate Median with 1 condition with AGGREGATE & PERCENTILE.INC function
5:56
2013-08-05
36
Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text
8:58
2013-08-12
37
Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL
22:03
2014-02-23
38
Excel Magic Trick 1101: Calculate MEDIAN Based On Lower/Upper Date, Exclude Holidays & Weekends
16:10
2014-04-21
39
Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method
12:59
2014-05-13
40
Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula
5:11
2014-05-15
41
Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula
26:34
2014-07-13
42
Private video
—
43
Excel Magic Trick 1198: Median for Each Quarter Using AGGREGATE Function
8:32
2015-05-21
44
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
45
Excel Magic Trick 1272: Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods)
7:38
2016-02-07
46
Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query?
17:18
2016-02-05
47
Excel Magic Trick 1284: History of Excel Max or Min with Conditions / Criteria (5 Examples)
14:38
2016-02-27
48
Excel Magic Trick 1285: OR Criteria & AND Criteria for Max & Min Calculations (5 Examples)
19:49
2016-02-29
