### Dueling Excel 150

July 12, 2017

DESCRIPTION See Mr Excel and excelisfun lookup the first value in column A when the first value in B is greater than 100: (00:13) Method 1: IF function and array operation inside MIN function inside […]

### Excel Magic Trick 1303

July 3, 2017

DESCRIPTION Learn how to to create three different formulas to calculate minimum value greater than zero: (00:13) Introduction (01:00) Before Excel 2010: =MIN(IF(C4:T4 greater0,C4:T4)) (03:05) Excel 2010 – 2013: =AGGREGATE(15,6,C4:T4/(C4:T4 greater0),1) (04:53) Excel 2016 or […]

### Dueling Excel 143

May 24, 2017

DESCRIPTION See Mr Excel and excelisfun create two solutions for looking up and calculating a percentage commission that does not exceed the max amount for some of the products. See the functions: VLOOKUP, MIN, and […]

### Highline Excel 2013 Class Video 32

April 21, 2017

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation […]

### Excel Magic Trick 1285

April 6, 2017

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]

### Excel Magic Trick 1284

April 3, 2017

History of Excel Max or Min with Conditions / Criteria (5 Examples) DESCRIPTION Learn about 5 methods to make a Max or Min AND Criteria (AND Logical Test) Calculation with multiple Conditions / Criteria that […]

### Excel Magic Trick 1254

December 8, 2016

DESCRIPTION Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula? Learn how to create solution to lookup an item where two values are closets in value: (00:10) Problem Introduction (00:36) Helper Column […]

### Dueling Excel 121

November 30, 2016

DESCRIPTION MIN and MAX Between Two Dates For Each Region See Mr Excel and excelisfun use two methods to calculate MIN and MAX Between Two Dates For Each Region (Minimum value and maximum value with […]

### Dueling Excel 111

October 7, 2016

Slowest Time That Is Within 2 Seconds Of The Fastest DESCRIPTION See Mr Excel and excelisfun use two methods to find the Slowest Time That Is Within 2 Seconds Of The Fastest: 1) Mr Excel: […]

### Dueling Excel 108

September 28, 2016

SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods DESCRIPTION See Mr Excel and Excelisfun calculate descriptive statistics: MIN, MAX, Standard Deviation, Average using three methods: 1) Data Analysis Toolpak Add-in, Descriptive Statistics 2) PivotTable 3) Functions […]