Dueling Excel

Dueling Excel 149

July 5, 2017 0

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

Dueling Excel

Dueling Excel 142

May 17, 2017 0

DESCRIPTION See Mr Excel and excelisfun do an average calculation with one condition: 1. PivotTable 2. Array Formula that uses AVERAGE and IF functions 3. SUMIF and COUNTIF together WORKBOOKS

Dueling Excel

Dueling Excel 128

February 8, 2017 0

DESCRIPTION Count Occurrences Of Items: PivotTable Or Advanced Filter & COUNTIF See Mr Excel and excelisfun use two methods to count the occurrences of items in a list: 1. PivotTable 2. Advanced Filter Extract Unique […]

Excel Is Fun

Excel Magic Trick 1246

November 10, 2016 0

DESCRIPTION Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT Learn how to create EXACT & SUMPRODUCT functions array formula to count with Case Sensitive Criteria in Excel: (00:09) Intro to topic and look back to […]

Dueling Excel

Dueling Excel 118

November 9, 2016 0

DESCRIPTION Formula To Calculate Commissions for Four Scenarios See Mr Excel and excelisfun use two methods to calculate the commissions based on the fact that the two sales people may both be at work for […]

Dueling Excel

Dueling Excel 102

September 14, 2016 0

Remove Duplicate Records Based On Partial Text in a Cell DESCRIPTION See Mr Excel and excelisfun use two methods to Remove Duplicate Records Based On Partial Text in a Cell using: 1. Formula with SUBSTITUTE, […]

Dueling Excel

Dueling Excel 91

August 5, 2016 0

Rank Scores, But If Tie Award Highest Rank To The Largest Weight DESCRIPTION See Mr Excel and excelisfun use two methods to rank scores with the heights Weight: 1. See how to use RANK or […]

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

Dueling Excel

Dueling Excel 84

June 29, 2016 0

Count Calls Every 15 Minutes Count Times Between Upper & Lower Limit DESCRIPTION See Mr Excel and excelisfun use two methods to count calls every 15 minutes: 1. a PivotTable and a Helper Column using […]