Dueling Excel

Dueling Excel 133

March 15, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with […]

Dueling Excel

Dueling Excel 121

November 30, 2016 0

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

Dueling Excel 111

October 7, 2016 0

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

Dueling Excel 108

September 28, 2016 0

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 […]

Dueling Excel

Dueling Excel 103

September 16, 2016 0

Find Missing Numbers In A Series DESCRIPTION See Mr Excel and excelisfun use two formula methods to Find Missing Numbers In A Series: See Mr Excel use the functions IF, ISNA, VLOOKUP, ROW, and SMALL […]

Dueling Excel

Dueling Excel 86

July 13, 2016 0

MODE or MEDIAN From Frequency Table Formula or VBA? DESCRIPTION See Mr Excel and excelisfun use two methods calculate MODE or MEDIAN From Frequency Table – Formula or VBA. See the functions, AND, COUNTIF, MAX, […]

Excel Is Fun

Excel Magic Trick 1167

October 8, 2015 0

Substitute Final Score If Greater Than Low Score: MAX, MIN & SUM Functions DESCRIPTION See how to Substitute Final Score If Greater Than Low Score using the MAX, MIN & SUM Functions. Adam Goodrich From […]

Dueling Excel

Dueling Excel 024

May 20, 2015 0

VLOOKUP, MAX, Boolean, IF, Which is Best? DESCRIPTION See Mr Excel and excelisfun throw out 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas. Which one do you like? […]

Excel 2010 Tutorial For Beginners

Excel 2010 Tutorial For Beginners #5

May 5, 2015 0

DESCRIPTION This updated tutorial shows how to use the following functions: AVERAGE, MAX, MIN and COUNT. The tutorial also shows how to create these functions in a variety of ways, including from the Functions tab […]

Excel 2013 PowerPivot Basics

Excel 2013 PowerPivot Basics 10

April 10, 2015 0

DESCRIPTION Topics in this video: (00:34) Essence of PivotTable (01:08) Overview of Filter Context and CALCULATE (02:30) Look at how Filter Context works on a Calculated Field (03:53) COUNTROWS function to see “Filtered Table” Example […]